Hello,
i'm trying to call an oracle procedure from a modperl script, which
works somewhat, but I need to get the return value from the procedure.
I followed some hints on websites/mailinglists i searched, but i still
haven't had any luck in succeeding.
This is what I use:
my $func = $dbh->prepare(q{
BEGIN
package.procedure(
p_1_id => :1stvalue,
p_2_id => :2ndvalue,
);
END;
});
I bind the 2 variables, which works.
If i use this:
my $func = $dbh->prepare(q{
BEGIN
:receive := mobile.process_url(
p_1_id => :1stvalue,
p_2_id => :2ndvalue,
);
END;
});
and then bind the :receive as bind_param(":receive",$receive); , it
doesnt work..
I get an error about wrong number of arguments, which seems to indicate
the binding is to the in instead of the out params.
Any hints?
Maarten
