Re: SQL*Plus Argument Character Limits

Which version of sql*plus are you using? Your assertion on no open file dialog box is simply *not* true. If you are using the plus<nn>w.exe you simply should have a file open dialog. Regards,

Sybrand Bakker, Oracle DBA

"Scott Edward Skinner" <sskinner_at_cloud9.net> wrote in message news:090720000024022460%sskinner_at_cloud9.net...
>
> Hello,
>
> I use SQL*Plus on both Mac and NT to check SQL statements that are
> dynamically created by Java. When I get a JDBC error, I typically copy
> the offending statement from the browser and past it directly into
> SQL*Plus. If the SQL statement is too long, SQL*Plus on the Mac crashes
> completely, while SQL*Plus for NT does not accept the entire argument.
>
> My Oracle DBA's have told me to manually break up the statements with
> carriage returns and feed each sub-statement piece by piece to
> SQL*Plus. I have tried this and it works, but it is cumbersome. I have
> also been told that SQL*Plus can read in a file containing the SQL
> statement, but this is also cumbersome because there is no open file
> dialogue box GUI or drag-and-drop support.
>
> What I really would like is to be able to cut and paste the statements
> without breaking them up. Is there a way to increase the character
> limit threshold to accept long SQL statements?
>
> Thanks in advance,
>
> -S
Received on Sun Jul 09 2000 - 00:00:00 CEST