SQL*Plus Argument Character Limits

Hello,

[Quoted] 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