Re: How to get a return code from an host command in SQL*Plus ?

Would it be a good idea to write the return code to a file, and then read it using UTL_FILE?

AW

> In article <8ep751$2vca$1_at_news4.isdnet.net>,
> > "Michel Cadot" <micadot_at_netcourrier.com> wrote:
> > >
> > > 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
> > > Michel
> > >
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Fri May 05 2000 - 00:00:00 CEST