Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
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


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

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (13)
As of 2014-12-26 17:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (174 votes), past polls