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

Thanks for your answer but i execute my program on the client station and utl_file reads only files on the server and, for security reasons, there is no connection on file systems between client and server.

--
Cheers
Michel


Andrew Williamson <andrewweb_at_my-deja.com> a écrit dans le message :
957536418.2566.0.nnrp-12.c30bdde2_at_news.demon.co.uk...


> 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.

> >

> >

>

>