There is a nasty bug in 10.2.0.1.0 sqlplus whereby previously fine 9i scripts abort with an error.
If you use the CLEAR SCREEN command in a sqlplus file, and run it from sqlplusw, all is well.
If however, you invoke exactly the same script via a batch file and call sqlplus, the clear screen command causes the script to bomb out completely.
Note that using abbreviated forms of the clear screen command also fails.
This is extremely difficult to find, as running the script native always gives a "no fault found" result, and it's only after tortuous debugging efforts that one can locate the offending item.
The only solution seems to be a swift upgrade to 10.2.0.3
Grinding away at things Oracular
If you use the CLEAR SCREEN command in a sqlplus file, and run it from sqlplusw, all is well.
If however, you invoke exactly the same script via a batch file and call sqlplus, the clear screen command causes the script to bomb out completely.
Note that using abbreviated forms of the clear screen command also fails.
This is extremely difficult to find, as running the script native always gives a "no fault found" result, and it's only after tortuous debugging efforts that one can locate the offending item.
The only solution seems to be a swift upgrade to 10.2.0.3
Grinding away at things Oracular
