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]


Reply via email to