Oracle DBA, How To, Error, Cause and Action

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

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


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.

No comments:

Post a Comment

Thanks for your comment.