Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06550 & PLS-00201

449323Aug 5 2005 — edited Sep 9 2005
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2005
Added on Aug 5 2005
3 comments
800 views