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: Calling sqlplus or plsql code from ksh

Re: Calling sqlplus or plsql code from ksh

From: Bit Twister <BitTwister_at_localhost.localdomain>
Date: Mon, 23 Feb 2004 00:49:17 GMT
Message-ID: <slrnc3ijgd.ulk.BitTwister@wb.home.invalid>


On 22 Feb 2004 16:08:43 -0800, capitaldog_at_hotmail.com wrote:

> Or do you just use $?

$? is not as big as you might think. Here try this

cat > x
  exit 512
^d <==== that is a control d

chmod +x x

  ./x         <=== to run
echo $?        <== is it 512 ?


What you do is spool your data to a file and pass a pass/fail (0/1) indicator from the sql for the script to check. Received on Sun Feb 22 2004 - 18:49:17 CST

Original text of this message

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