Databases
StackOverflow2013
Postsdbo
POHow do I capture a SQLPlus exit code within a shell script?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I capture a SQLPlus exit code within a shell script?
    primarykey
    data
    text
    <p>I have a KornShell (ksh) script that logins into SQL*Plus and executing a script. Within the shell script I would like to capture the status code of the SQL statement that was executed. Currently there is an error with SQL and I am unable to capture it by checking $?. How would I capture the success or error code from the sql statement and pass it to the shell script.</p> <p><strong>Snippet of ksh script:</strong></p> <pre><code>sqlplus $JDBC_FBUID_U/$JDBC_FBPWD_U@$JDBC_FBDB @${FBC_HOME}/FBCS003.sql ${outputfile} if [ $? != 0 ] then msg_txt="The execution of Sql script /tmp/FBCS003.sql failed. Please investigate." echo ${msg_txt} echo ${msg_txt} | mailx -r ${fromemail} -s "FBCB003: The execution of Sql script /tmp/FBCS003.sql failed." ${toemail} epage -n ${pagerdef} ${pagernum} "FBCB003: ${msg_txt}" exit 1 fi </code></pre> <p><strong>SQL script FBCS003.sql</strong></p> <pre><code>-- Set SQLPlus variables. SET NEWPAGE 0 SET WRAP OFF SET LINESIZE 9999 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET PAGESIZE 0 SET COLSEP | SET TRIMSPOOL ON SET TIMING ON -- Open output file -- The file path and name are passed from the calling script FBCS003. spool &amp;1 -- Main Select Statement select ct.fiscal_yr_no, ct.acct_per_no, ct.bus_unit_id, ct.btch_file_seq_no, ct.comm_tran_srce_cd, ct.rec_no, ct.rev_gl_acct_no, ct.gl_prod_cd, ct.prod_desc, ct.paid_ir_no, ct.srce_ir_no, ct.ir_no_house_acct_rsn_txt, ct.vndr_acct_ty_id, ct.clnt_na, ct.issr_na, ct.clnt_na, ct.issr_na, ct.trd_da, ct.setl_da, ct.ord_ty_cd, ct.actv_ty_cd, ct.prin_amt, ct.grs_comm_amt, ct.net_comm_amt, ct.vndr_prod_ty_cd, ct.vndr_stmt_id from fin.comm_tran ct where ct.bus_unit_id = 'EJL' and ct.vndr_acct_ty_id in ('11111111','222222222') -- Execute sql statement. / -- Close output file spool off -- Exit SQL exit / </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USjavaPlease42
    1. USAieshaDot
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow do I capture a SQLPlus exit code within a shell script?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow do I capture a SQLPlus exit code within a shell script?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow do I capture a SQLPlus exit code within a shell script?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload