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-01032: no such userid

1 Answers  


ORA-08230: smscre: failed to allocate SGA

1 Answers  


ORA-02707: osnacx: cannot allocate context area

1 Answers  


PLS-00458: subprogram 'string' cannot be called from a REPEATABLE subprogram

1 Answers  


DRG-11435: primary key value is invalid

1 Answers  






TNS-00537: Index into protocol adapter table is out of legal range

1 Answers  


ORA-36681: (XSDPART19) Partitions string and string are out of order.

1 Answers  


DGM-16949: "string" was not found

1 Answers  


SQL*Loader-00645: error converting character length field to a number

1 Answers  


ORA-06137: NETTCP: error during connection handshake

1 Answers  


TNS-02511: Invalid data type

1 Answers  


DRG-51022: undefined error in stemmer

1 Answers  


Categories