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) is begin open p_cursorVar for select emp_id, emp_name from emp; End pension_rank;
In Section
Seekers of Perl Wisdom