Re: Do "imp", "exp", and "sqlplus" return status?

Chuck Hamilton wrote:
>
> On 6 Jan 1998 22:38:09 GMT, "Anthony Sute" <asute_at_engagetech.com>
> wrote:
>
> >Hello All:
> >
> >Do "imp", "exp", and "sqlplus" return status codes on Oracle 7.3/NT? The
> >driver for my application consists of a Bourne shell script (being run with
> >the GNU/Cygnus "bash" shell interpreter) calling these utilities to unload
> >and load tables to files, and having to check the return codes from them to
> >determine success. All I really care about is if the calls were entirely
> >successful or not (I am hoping that "0" is returned if successful, and any
> >non-zero value returned if an error is encountered).
> >
> >I'd appreciate it if replies could be e-mailed to me at "asute_at_cmgi.com".
> >
> >Thanks in advance!
> >
> >- Anthony Sute
>
> exp and imp do. sqlplus always returns a 0 unless you issue a sqlplus
> command like this...
>
> whenever sqlerror exit failure
> -or-
> whenever sqlerror exit sql.sqlcode
>
> --
> Chuck Hamilton
> chuckh_at_dvol.com
>
> Never share a foxhole with anyone braver than yourself!

Beware! exp can fail to export a table and still end with a zero code! Received on Wed Jan 07 1998 - 00:00:00 CST