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