vrgurav 0 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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.