| | |
How to call oracle procedure having out parameter using shell script
Please support our Shell Scripting advertiser: Programming Forums - DaniWeb Sister Site
![]() |
•
•
Join Date: Jun 2007
Posts: 11
Reputation:
Solved Threads: 1
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
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
- How to su properly in a shell script (Shell Scripting)
- Passing a structure into an Oracle Procedure (ColdFusion)
- shell script prob (Shell Scripting)
- Problem with variables in Windows shell script (Windows NT / 2000 / XP)
- Why my shell script doesn't delete a file ?? (Shell Scripting)
- Shell Script for Gnome 2.6 Print Manager. (Shell Scripting)
Other Threads in the Shell Scripting Forum
- Previous Thread: Display a file using grep
- Next Thread: How to insert " " in between column in a file
Views: 8290 | Replies: 0
| Thread Tools | Search this Thread |
Tag cloud for Shell Scripting





