Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

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!

-Daruma

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://274877]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (5)
As of 2016-12-03 21:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (60 votes). Check out past polls.