ORA-02027: multi-row UPDATE of LONG column is not supported



ORA-02027: multi-row UPDATE of LONG column is not supported..

Answer / guest

Cause: A bind variable with length greater than 4000 bytes
is being used to update a column, and the update statement
updates more than one row.

Action: You may only update a single row with such a bind
variable.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-20006: target database name is missing

1 Answers  


ORA-31215: DBMS_LDAP: PL/SQL - Invalid LDAP mod value.

1 Answers  


ORA-14263: new subpartition name must differ from that of any other subpartition of the object

1 Answers  


ORA-13835: invalid attribute name specified

1 Answers  


ORA-26092: only LONG or LOB types can be partial

1 Answers  


ORA-39080: failed to create queues "string" and "string" for Data Pump job

1 Answers  


ORA-25003: cannot change NEW values for this column type in trigger

1 Answers  


ORA-22813: operand value exceeds system limits

1 Answers  


TNS-12561: TNS:unknown error

1 Answers  


PCC-02447: Cannot specify destination offset in a LOB WRITE APPEND

1 Answers  


SQL*Loader-00606: Object string in INTO TABLE clause is not a local table

1 Answers  


ORA-26006: Incorrect bind variable in column string's sql expression - string

1 Answers  


Categories