Re: sqlplus return codes on unix
From: Hui, Kwok Miu <huikomix_at_dt.com.hk>
Date: 1997/01/03
Message-ID: <32CD42C2.40D2_at_dt.com.hk>#1/1
Date: 1997/01/03
Message-ID: <32CD42C2.40D2_at_dt.com.hk>#1/1
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 3049Received on Fri Jan 03 1997 - 00:00:00 CET