execute pl/sql block from perl program

can you please provide guidance with code examples on executing a pl/sql block with input values from a perl program?

thanks
eagle_eaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
wilcoxonConnect With a Mentor Commented:
I don't personally use Oracle and don't have time to post multiple detailed examples but this is the basic flow.  What sorts of PL/SQL blocks do you want to execute (it's very hard to come up with examples without more details).
use strict;
use warnings;
use DBI;
my $dbh = DBI->connect('oracle...');
$dbh->do("some PL/SQL block that does not return values");
my $ret = $dbh->selectall_arrayref("some PL/SQL block that does return values");

Open in new window

For more complicated things, you can also look at statement handles.
0
 
wilcoxonCommented:
You want to look at the DBI and DBD::Oracle modules.
0
 
eagle_eaAuthor Commented:
assuming that is already in place, can you post an example of the code?
0
All Courses

From novice to tech pro — start learning today.