•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Shell Scripting section within the Software Development category of DaniWeb, a massive community of 456,433 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,638 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Shell Scripting advertiser: Programming Forums
Views: 4809 | Replies: 0
 |
•
•
Join Date: Jun 2007
Posts: 11
Reputation: 
Rep Power: 2
Solved Threads: 1
Newbie Poster
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
|
•
•
•
•
•
•
•
•
DaniWeb Shell Scripting Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Passing a structure into an Oracle Procedure (ColdFusion)
- shell script prob (Shell Scripting)
- Problem with variables in Windows shell script (Windows NT / 2000 / XP / 2003)
- Why my shell script doesn't delete a file ?? (Shell Scripting)
- Shell Script for Gnome 2.6 Print Manager. (Shell Scripting)
- How to su properly in a shell script (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
