ORA-01704: string literal too long

I got ” ORA-01704: string literal too long ”  error in Oracle database.

ORA-01704: string literal too long

Details of error are as follows.

ORA-01704: 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.

string literal too long

This ORA-01704 error is related with the string literal is longer than 4000 characters.

Use a string literal of at most 4000 characters. Longer values may only be entered using bind variables.

OR

You need to split the characters into multiple parts as follows.

Insert into table_name (clob_column) values ( to_clob( 'part 1' ) || to_clob( 'part 2' ) );

Do you want to learn Oracle Database for Beginners, then read the following articles.