943,771 Members | Top Members by Rank

Ad:
Jul 31st, 2007
0

How to call oracle procedure having out parameter using shell script

Expand Post »
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
Similar Threads
Reputation Points: 10
Solved Threads: 1
Newbie Poster
vrgurav is offline Offline
11 posts
since Jun 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Shell Scripting Forum Timeline: Display a file using grep
Next Thread in Shell Scripting Forum Timeline: How to insert " " in between column in a file





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC