Re: Passing return codes from PL/SQL to SQLPlus script to OS
From: <vinduc_at_my-deja.com>
Date: Thu, 06 Jan 2000 09:49:21 GMT
Message-ID: <851oeu$gfp$1_at_nnrp1.deja.com>
Date: Thu, 06 Jan 2000 09:49:21 GMT
Message-ID: <851oeu$gfp$1_at_nnrp1.deja.com>
You can use the following syntax in your Shell Script :
BATCH_NUMBER=`sqlplus -s scott/tiger <<EOF
set heading off
set pagesize 0
set termout on
set wrap on
set feedback off
set echo off
set serveroutput on
execute rahpkg.testa ('hello');
exit
EOF`
And in your PL/SQL code at the end of rahpkg.testa, add the following
statement
- Display id dbms_output.put_line(id);
Hope it will help
Regards
vinduc_at_hotmail.com
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Jan 06 2000 - 10:49:21 CET