ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

DELETE_VAR on 4000+ char XML gives ORA-19011 error


Article ID: 88071


Updated On:


CA Automic Workload Automation - Automation Engine


Error Message :
ORA-19011: Character string buffer too small.

If the Automation Engine has an Oracle DB backend, when using the script command DELETE_VAR on an XML Variable of over 4000 characters, the command will fail and display the above error.


Cause type:
Root Cause: If you use the Automation Engine with an Oracle database, the attribute values of XML data used in this Variable object can't contain more than 4000 characters.


OS Version: N/A


Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Automation Engine 12.0.2 - Available
Automation Engine 11.2.5 - Available

Additional Information

Workaround :
Delete from the XML Variable manually.