Wednesday, October 2, 2002 06:30 AM
When you say a "script", I assume you mean a file of SQLPlus commands, that you would run in "SQLPlus"? (e.g., valid SQL statements plus some Oracle proprietary extension statements just for SQLPlus' benefit, such as "set serverout on", "ttitle", "set linesize", or any of its "set" commands etc.?)
How would you imagine running such a thing inside Java, instead of inside SQLPlus? You could run each valid SQL statement as a JDBC statement, as long as the SQLPlus proprietary extension statements aren't crucial to the results.
If the SQLPlus extensions are important though (e.g. if you use serverout to get your final number output, etc.) then your best bet might be, in the short term, to just run SQLPlus, from inside Java. But then you wouldn't get your ResultSet out of it.