From: "Andrew Williamson" <andrewweb@my-deja.com>
Subject: Re: How to get a return code from an host command in SQL*Plus ?
Date: 2000/05/05
Message-ID: <957536418.2566.0.nnrp-12.c30bdde2@news.demon.co.uk>#1/1
X-NNTP-Posting-Host: mailgate.highland.gov.uk:195.11.221.226
References: <8ep751$2vca$1@news4.isdnet.net> <8epftt$574$1@nnrp1.deja.com> <8errsg$17bh$1@news5.isdnet.net>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: abuse@demon.net
X-Trace: news.demon.co.uk 957536418 nnrp-12:2566 NO-IDENT mailgate.highland.gov.uk:195.11.221.226
X-MSMail-Priority: Normal
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools


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@news4.isdnet.net>,
> >   "Michel Cadot" <micadot@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.
>
>