How to call oracle procedure having out parameter using shell script

Please support our Shell Scripting advertiser: Programming Forums - DaniWeb Sister Site
Reply

Join Date: Jun 2007
Posts: 11
Reputation: vrgurav is an unknown quantity at this point 
Solved Threads: 1
vrgurav vrgurav is offline Offline
Newbie Poster

How to call oracle procedure having out parameter using shell script

 
0
  #1
Jul 31st, 2007
Hi all,
can any one help me to solve the below query

#!/bin/ksh

#create or replace procedure a1 (a in number, b out varchar2)
#is
#begin
--for testing purpose
# b :='OKAY';
#end;


$ORACLE_HOME/bin/sqlplus -s $userid << EOF
set timing on
set arraysize 5000
set serveroutput on size 1000000
exec a1 ($ftpno,sp_status);
exit;
EOF


not working



Thanks & regards
vishal
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:




Views: 8290 | Replies: 0
Thread Tools Search this Thread



Tag cloud for Shell Scripting
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC