Re: How to call Oracle stored procedures?

I've been using DBIx::ProcedureCall for a while now and have no complaints. Perhaps something like the following untested code would work for you.

...
use Data::Dumper;
use DBIx::ProcedureCall qw(Mrf_Maint.check_user:packaged:cursor:fetch)
+;
...

$accessroles = Mrf_Maint::check_user( $login_id, [ \$accessroles, 0 ] 
+);
  
print Dumper($accessroles);
[download]

Comment on Re: How to call Oracle stored procedures? Download Code

Replies are listed 'Best First'.
Re^2: How to call Oracle stored procedures? by Anonymous Monk on Feb 06, 2009 at 11:55 UTC
if you are trying to embed or execute a sql procedure in ant script use the following <sql ...............> <transaction>call mystoredprocedure();</transaction> </sql> -by nagaraj mamedi	[reply]