can You please suggest why I am getting the error in following code;
$test_num="500212275";
$sql='begin CDI1_GETSEQ_PKG.CDI1_GETphoneID_PROC(:test_num); end;';
$sth = $dbh->prepare( $sql);
$sth->bind_param(":test_num", $test_num);
$sth->execute();
print "[EMAIL PROTECTED]";
$sth->finish()
when I ran the procedure in sql sheet it is sussessful.
The error is as below
DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
PLS-00221: 'CDI1_GETPHONEID_PROC' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored (DBD: oexec error) at test.pl line 9.
Biswajeet
