Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Do "imp", "exp", and "sqlplus" return status?

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

From: Patrick Tan <ptan_at_mindspring.com>
Date: 1998/01/07
Message-ID: <34B395DB.845C9DD5@mindspring.com>#1/1

SQLPLUS does return status of 0 when finish. For example, you want to return exit code 1 in SQLPLUS, you code

whenever sqlerror exit 1
whenever oserror exit 1

at the beginnig of the script, any ORA-XXXX error including the error you raise in PLSQL will abort SQLPLUS with exit code 1. Good Luck.

Patrick Received on Wed Jan 07 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US