Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: executing a OSP with CGI

by Daruma (Curate)
on Jul 16, 2003 at 15:47 UTC ( #274877=note: print w/replies, xml ) Need Help??

in reply to executing a OSP with CGI

Greetings, chuleto1!

When executing an existing stored procedure via DBI, I have often used a structure like the following:
sub call_assign_value_func { my $some_num = shift; my $func_value = -1; my $pkgh = $dbh->prepare("BEGIN :result := PKG_SIMULATOR.F_ASSIGN_VALUE(:some_num); END;"); $pkgh->bind_param(":some_num", $some_num); $pkgh->bind_param_inout(":result", \$func_value, 15); $pkgh->execute(); return $func_value; }
I am basically creating an anonymous PL/SQL block to execute the desired stored procedure, (or function in this case.) Using the $pkgh->bind_param and $pkgh->bind_param_inout calls allows for much greater flexibility when working with some of the stored procedures I have.

Hope this helps!


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://274877]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2016-10-26 23:15 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (350 votes). Check out past polls.