ranijoseph:
As the Anonymous Monk states above, it's the namespace the package resides in. I'm using DBI with DBD::Oracle, so the code may not be exactly what Win32::ODBC would use.
The code would be something like:
...
my $ST=$DB->prepare("call apps.package_name.sp_rank(?)");
my ($ST_result);
...
$ST->bind_param_inout(1, \$ST_result, 0, { ora_type=>ORA_RSET } );
$ST->execute();
while (my $hr = $ST_result.fetchrow_hashref) {
... process data ...
}
But in any case, to call the procedure, you just use a "call SPROC(args...)" statement as you would normally use "select * from table". The difficulty may be in returning a recordset. For DBD::Oracle we bind another variable ($ST_result above) to the output cursor, and then we can treat it as a statement handle and retrieve the results from it. You'll have to fiddle with that to make it work in Win32::ODBC.
...roboticus
When your only tool is a hammer, all problems look like your thumb. |