ORA-01461: can bind a LONG value only for insert into a LONG column
Article ID: 253944
Updated On:
Products
Issue/Introduction
Scenario: User is running a Automic script object which saves some data in a VARA.xml with Oracle DB at the backend - This script runs into a ORA-01461 error which results in a FATAL DB ERROR causing the DB to disconnect.
Error from the log:
U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
U00003592 UCUDB - Status: '' Native error: '1461' Msg: 'ORA-01461: can bind a LONG value only for insert into a LONG column'
U00003536 UCUDB: FATAL DATA BASE ERROR: Re-connection will be attempted in 10 seconds.
U00003538 UCUDB: Re-connection to database successful. Processing will continue.
U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
Expected Behavior: When this can result in a script execution failure - This should not cause the database error.
Environment
Release: 21.x
Component: Automation Engine
Database Platform: Oracle
Cause
- The script failure happens if the data is more than 4000 characters when using Oracle DB - This restriction is by design
Restriction: With an Oracle database, the attribute values of XML data should not contain more than 4000 characters.
- UCUDB: FATAL DATA BASE ERROR - This is identified as a bug
Resolution
This has been fixed with the release of 21.0.5, available 13 February, 2023
Additional Information
Feedback
