Connecting Tech Pros Worldwide Help | Site Map

stored procedure from php

cool_dude7244@yahoo.com
Guest
 
Posts: n/a
#1: Jul 17 '05
Hi,
I have this simple stored procedure:
create or replace procedure CHGCUSTSTATUS as
i number;
begin....

I am calling it from PHP as
$query = "begin CHGCUSTSTATUS";
$result = ora_parse($cursor,$query);

I am getting the error:
Ora_Parse failed (ORA-06550: line 1, column 19: PLS-00103: Encountered
the symbol "end-of-file" when expecting one of the following: := . ( @
% ; -- while processing OCI function OPARSE)

What is(are) the mistakes in my code?

Thanks heaps,
CD

Closed Thread