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.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.