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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: EXIT SQL.SQLCODE and ksh

RE: EXIT SQL.SQLCODE and ksh

From: Jared Still <jkstill_at_bcbso.com>
Date: Sun, 17 Sep 2000 18:08:14 -0700 (PDT)
Message-Id: <10622.117215@fatcity.com>


> error= `sqlplus lisa/shutup << !

Is that a joke? It's in poor taste if so.

If not a joke, please don't make posts like this.

Jared

On Fri, 15 Sep 2000, Davide Bellesi wrote:

> Hi
>
> error= `sqlplus lisa/shutup << !
> begin
> ...
> exception
> dbms_output.put_line(sqlcode);
> end;
> exit;
> ! `
>
> echo $error
>
>
> Davide
>
> -----Original Message-----
> Sent: Fri, 15 Sep 2000 01:35:49 -0800
> To: ORACLE-L_at_fatcity.com
>
>
> Hi Lisa,
>
> echo $?, echoes the last return code from a program.
> But there is a problem: unix program return codes are from 0 to 255 (I
> think)
>
> HTH
>
> Joselu
> http://www.oraes.com
>
> > -----Mensaje original-----
> > De: Koivu, Lisa [SMTP:lkoivu_at_qode.com]
> > Enviado el: jueves 14 de septiembre de 2000 21:56
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: EXIT SQL.SQLCODE and ksh
> >
> > Anyone know how to catch this value in a ksh script? I believe I've seen
> > it done before but I just can't remember how. For example:
> >
> > ...ksh script executing
> >
> > sqlplus lisa/shutup << !
> > whenever sqlerror exit sql.sqlcode
> >
> > ..statements...
> > exit;
> > !
> >
> > Do something with the error value down here in the ksh script.
> >
> > Thanks everyone
> > GO VIKINGS!
> >
> > Lisa Rutland Koivu
> > Oracle Database Administrator
> > Qode.com
> > 4850 North State Road 7
> > Suite G104
> > Fort Lauderdale, FL 33319
> >
> > V: 954.484.3191, x174
> > F: 954.484.2933
> > C: 954.658.5849
> > <http://www.qode.com>
> >
> > "The information contained herein does not express the opinion or position
> > of Qode.com and cannot be attributed to or made binding upon Qode.com."
> >
> --
> Author: Marina Leonardo, Jose Luis
> INET: JLMarina_at_Uni2.es
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
> ___________________________________________________________________________
> Visit http://www.visto.com/info, your free web-based communications center.
> Visto.com. Life on the Dot.
>
> --
> Author: Davide Bellesi
> INET: davide.bellesi_at_visto.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon Received on Sun Sep 17 2000 - 20:08:14 CDT

Original text of this message

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