Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

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 meditating upon the Monastery: (5)
As of 2015-10-09 23:00 GMT
Find Nodes?
    Voting Booth?

    Does Humor Belong in Programming?

    Results (253 votes), past polls