Return
-
Title
Error, "ORA-01704: string literal too long" when running Merge statement exported from CLOB that -
Description
I'm trying to export a query that contains a CLOB column as a Merge Statement format and my CLOB column has about 5000 characters of data. The generated Merge statement from Toad puts CLOB string into several new lines and when I attempt to run the Merge statement in Toad I get the following error:
ORA-01704: string literal too long,If I try to run the same Merge statement in SQL Plus I receive sever errors as the following:,SP2-0734: unknown command beginning "RTD''''s, ..." - rest of line ignored.
SP2-0734: unknown command beginning "Resolution..." - rest of line ignored.
SP2-0734: unknown command beginning "Discrete O..." - rest of line ignored.
SP2-0042: unknown command "10-30 Vdc" - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT. -
Cause
Oracle thinks each newline for the CLOB is it own literal or statement and because it's incomplete as it own literal, SQL Plus will ignore it.
-
Resolution
WORKAROUND:
Manually place the entire string of the CLOB onto one line in the Toad editor and the Merge statement will run.
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle. -
Defect ID
ST72033