ORA-06550 & PLS-00201
449323Aug 5 2005 — edited Sep 9 2005I keep getting the following warning from a small PHP program I wrote:-
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-06550:
line 1, column 7: PLS-00201: identifier 'SPMEMBERDETAIL' must be
declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored in
C:\Program Files\Apache Group\Apache2\htdocs\Kiosk\GetMember3.php on
line 53
The code around the warning looks like:-
$s = OCIParse($c, "begin spMemberDetail(:number); end;");
OCIBindByName($s, ":number", &$number, -1);
$exec = OCIExecute($s, OCI_COMMIT_ON_SUCCESS);
& line 53 is the OCIExecute line
So I suspect that there must be something wrong on the OCIParse line where I call a stored procedure.
I have little idea where to go next, please help.
What I did not point out was that the Stored Procedure and UID and Password I am using are being successfully used by other programs in the same environment.