Re: Pass Return Code to Shell

From: Candeman1 <candeman1_at_aol.com>
Date: 1996/04/09
Message-ID: <4kfaop$d4g_at_newsbf02.news.aol.com>#1/1


In article <4jrokg$2jl_at_news.dca.net>, jennings_at_dca.net (Ed Jennings) writes:

>I'm running SQL scripts within a Kourne Shell script. If the
>SQL encounters an error, I want the return code to be propagated
>out to the shell return code ($?). Does anyone know how to do this??

In the SQLPlus script, as the first line:

whenever sqlerror exit sql.sqlcode

Steve Stutheit Received on Tue Apr 09 1996 - 00:00:00 CEST

Original text of this message