Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Return code from sql script runned by sqlplus from a script Unix

425367Jul 14 2004 — edited Jul 14 2004
Hello World,

I'm searching a solution to dispose a set of return code value from execution of script SQL runned by sqlplus inside a unix script or a batch file Wondows.

The script unix is a batch file where many actions are done in my application. According to the different return code of the script SQL execution, the actions wil be different. A test of the return code is needed.

I dont't know how to do that kind of code in PL/SQL script. I try using the EXIT function, but the result I obtain is not good.

Have you any ideas to do it ? Samples of code ?

Thank's in advance

Michel.


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2004
Added on Jul 14 2004
4 comments
953 views