my recollection from oracle 7 (though at the moment I can't back it up
readily with a citation) is that a sql statement (as prepared) had to
fit in a varchar2. that's as _prepared_, so bound data wasn't counted.
so in o7, that was 2000 characters. I'm not sure if it is 2000 or 4000
in o8; or even if o8 structures the restriction similiarly.
- mark
Warden, Ronald MCF:EX wrote:
> What is the maximum size of a SQL statement that the DBD::ORACLE and DBI can
> handle? I have a select statement that is 2183 character long, it fails in
> the execute phase. That is to say the prepare works fine, yet the execute
> produces and error ( the error is that the SYSTEM table fails on an extend.
> Yes, I have add 700 MB more to the SYSTEM table and I still get the error.
> The error occurs on the very first pass, even before I try to do a fetch.)
>
> Thanks for the help.
> ---
> Ronald Warden
> Corporate Data Manager
> 250.356.0466
> Data Services Branch
> Ministry for Children and Families
>
