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

ORA-06265: NETNTT: break protocol error

1 Answers  


ORA-03248: Too much of segment creation activity during migration

1 Answers  


ORA-03296: cannot resize datafile - file string not found

1 Answers  


ORA-32164: Method called on Invalid Connection type

1 Answers  


ORA-14453: attempt to use a LOB of a temporary table, whose data has alreadybeen purged

1 Answers  


ORA-31052: Cannot delete ACL with other references

1 Answers  


ORA-13150: failed to insert exception record

1 Answers  


ORA-15057: specified size of string MB is larger than actual size of string MB

1 Answers  


ORA-00072: process "string" is not active

1 Answers  


ORA-14296: Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 Answers  


ORA-22280: no more buffers available for operation

1 Answers  


SQL*Loader-00466: Column string does not exist in table string.

1 Answers  


Categories