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-08177: can't serialize access for this transaction

1 Answers  


ORA-27214: skgfrsfe: file search failed

1 Answers  


ORA-02711: osnpvalid: write to validation channel failed

1 Answers  


ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

1 Answers  


ORA-22909: exceeded maximum VARRAY limit

1 Answers  






ORA-08466: raw buffer length string is too short for string

1 Answers  


RMAN-05503: at least one auxiliary channel must be allocated to execute this command

1 Answers  


NID-00503: DBNAME New database name (NONE)

1 Answers  


SQL*Loader-00509: System error: string

1 Answers  


ORA-29862: cannot specify FORCE option for dropping non-domain index

1 Answers  


ORA-39017: Worker request not supported when job is in string state.

1 Answers  


ORA-16509: the request timed out

1 Answers  


Categories