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

Home -> Community -> Usenet -> c.d.o.misc -> Can EXIT cause SQLPlus to have a different return value?

Can EXIT cause SQLPlus to have a different return value?

From: John Warner <john.warner_at_tivoli.com>
Date: Thu, 10 Jun 1999 14:34:16 -0500
Message-ID: <37601338.401E59E@tivoli.com>


I have a situation where I need to monitor the results of a SQL statement executed by SQLPlus (possibly isql) to determine what action to take in some third party software. However, regardless of what the SQL statement does, SQLPlus always returns a 0 because it (SQLPlus) correctly terminated. How can I cause SQLPlus to return something other than zero based on the results of the SQL statement? I've looked at the EXIT statement but that doesn't appear to do what I need.

Thanks in advance!

--
John Warner
Tivoli Systems Inc.
john_warner_at_tivoli.com Received on Thu Jun 10 1999 - 14:34:16 CDT

Original text of this message

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