in reply to Re: Calling Oracle StoredProc using Win32:ODBC
in thread Calling Oracle StoredProc using Win32:ODBC
Thank you so much for the reply.
I didn't understand the code very well.
my $ST=$DB->prepare("call apps.package_name.proc(?, ?, ?)");
what is apps?
If we don't want to pass parameter, are we declare like my $ST=$DB->prepare("call apps.package_name.proc").
Could you please give me the code for calling the following procedure.
Thank you so much for your time.
PROCEDURE sp_rank(p_cursorVar out CursorType)
open p_cursorVar for
select emp_id, emp_name from emp;