SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01704 string literal too long

Mathew1906Nov 15 2018 — edited Nov 16 2018

Hi All,

I am facing an issue while trying to update a column in a table in Oracle SQL Developer

I am getting the following error as follows

QL Error: ORA-01704: string literal too long

01704. 00000 - "string literal too long"

*Cause: The string literal is longer than 4000 characters.

*Action: Use a string literal of at most 4000 characters.

Longer values may only be entered using bind variables.

Could you please suggest a workaround for this

Regards,

Mathew

Added on Nov 15 2018

6 comments

16,018 views