Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

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!


Comment on Re: executing a OSP with CGI
Select or Download Code

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 imbibing at the Monastery: (6)
As of 2015-11-28 15:20 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (743 votes), past polls