Hi,
I am trying to run an oracle stored procedure through the DBI the
procedure is stored in a package.
In the DBI faq it say that this is possible but I can not seem to get
it working.
This is the code I am using
#!/usr/local/bin/perl
use DBI;
use CGI;
print "Content-Type: text/html\n\n";
BEGIN {
$ENV{ORACLE_HOME} = '/u04/app/oracle/product/OraHome1';
$ENV{TWO_TASK} = 'DB';
}
$dbh = DBI->connect("dbi:Oracle:host=delphi;sid=cs2000", "*******",
"*******");
$sth = $dbh->prepare("BEGIN sess.make(:1,:2); END;");
$sth->bind_param(1, 'meep');
$sth->bind_param(2, '110183');
$rc = $sth->execute;
print "test";
}
$dbh->disconnect;
Could you please tell me where I am going wrong as I need to get this
working.
Thanks,
Adam Gent
[EMAIL PROTECTED]