Hi there!
I'm trying to execute an Oraqcle PL/SQL procedures, but it does not work.
I think the code looks fine and maybe the oracle procedure itself causes the error (I hope this is right, so it is the admins fault ;-)).
Can anyone ratify that my code is okay or correct it?
Here's the code:
$query = "begin insert_person(0, 'Sebastian', 'Korten', 'Hiwi', 1, '',0,0); end;";
$sth = OCIParse ($connection, $query);
OCIExecute ( $sth );
and here the error message:
Warning: OCIStmtExecute: ORA-06550: line 1, column 7: PLS-00221: 'INSERT_PERSON' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL:
Statement ignored in /import/php/knobloch/o.face/gui/test_plsql.php on line 31
so long,
Michael
I'm trying to execute an Oraqcle PL/SQL procedures, but it does not work.
I think the code looks fine and maybe the oracle procedure itself causes the error (I hope this is right, so it is the admins fault ;-)).
Can anyone ratify that my code is okay or correct it?
Here's the code:
$query = "begin insert_person(0, 'Sebastian', 'Korten', 'Hiwi', 1, '',0,0); end;";
$sth = OCIParse ($connection, $query);
OCIExecute ( $sth );
and here the error message:
Warning: OCIStmtExecute: ORA-06550: line 1, column 7: PLS-00221: 'INSERT_PERSON' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL:
Statement ignored in /import/php/knobloch/o.face/gui/test_plsql.php on line 31
so long,
Michael