How to get a return code from an host command in SQL*Plus ?
From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/05/03
Message-ID: <8ep751$2vca$1_at_news4.isdnet.net>#1/1
Date: 2000/05/03
Message-ID: <8ep751$2vca$1_at_news4.isdnet.net>#1/1
[Quoted] In a SQL*Plus script, i have to launch an host command, then test its return code and go on with the SQL script only if it is 0.
How to get and test this return code?
Example:
SQL> select * from emp where ...; SQL> host myProg SQL> if myProg return code is not 0 exit <-- Can i do this and how? SQL> update emp set ...
-- Thanks MichelReceived on Wed May 03 2000 - 00:00:00 CEST