Re: literal string to long, Reformating query to work

For most of the time I have worked with Oracle the maximum size of an SQL statement has been 64k. The 9.2 Reference manual chapter on Database Limits still shows the largest size an SQL statement can be is 64k though the manual points out some tools impose lower limits.

Is the total size of the SQL statement over 64k? If so then you will need to separate the LOB from the target table row. If the statement length including the LOB data is under 64k then you may want to check into the ODBC limit.

See my previous post for some possible work-arounds.

HTH -- Mark D Powell -- Received on Thu Aug 04 2005 - 09:04:10 CDT