Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: literal string to long, Reformating query to work

Re: literal string to long, Reformating query to work

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 4 Aug 2005 07:04:10 -0700
Message-ID: <1123164250.679985.279200@g14g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US