Re: Size of SQL Statement
Date: 15 Aug 1994 21:45:22 GMT
Message-ID: <32onli$a7g_at_dcsun4.us.oracle.com>
In <georgecCuFL3B.Jwo_at_netcom.com>, georgec_at_netcom.com (George V Chianese) writes:
>Carl Hoang (choang_at_tdkt.mn.org) wrote:
>: What's the size of the biggest SQL statement that Oracle can have? Thanks.
>: Carl Hoang choang_at_tdkt.mn.org
>
>The largest SQL statement that Oracle can pass to the kernal is 64K. If you
>attempt a longer one, it will hang the session. There is also an issue that
>I read about recently with Forms being limited to 32K statement, but I can't
>confirm that.
>
>George Chianese
>Dallas Softworks, Inc.
V7-based tools/programs have a virtually no limit on the size of SQL statements that can be passed, as long as they are 32-bit programs [not Windows 3.1, DOS, or OS/2 1.x].
16-bit programs are limited to 64K [or 32K due to bugs].
Dave Colello
dcolello_at_oracle.com
The views expressed here are my own and not my employer's. Received on Mon Aug 15 1994 - 23:45:22 CEST