Re: sqlplus return codes on unix

Chuck Hamilton wrote:
>
> Is there a way to get the full return code from SQLPLUS back to a unix
> shell script? Unix only looks at the low-order byte. Is there perhaps
> a specific shell that'll get a two byte return code?

Oracle Manual says what you stated cannot be achieved.

If you want to know your SQL statements runs correctly, you may use 'SHOW SQLCODE' to get Oracle Error Code.

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049