Connecting Tech Pros Worldwide Help | Site Map

stored procedure from php

  #1  
Old July 17th, 2005, 01:53 PM
cool_dude7244@yahoo.com
Guest
 
Posts: n/a
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
call MySQL stored procedure from php Urmi Biswas answers 5 November 20th, 2008 05:25 PM
how to call mysql stored procedure from php sbettadpur answers 1 March 29th, 2008 04:07 PM
mysql vs. mysqli, how to call stored procedure from php eholz1 answers 1 February 27th, 2007 11:15 PM
SQL Stored Procedure from PHP Chad L answers 4 November 22nd, 2005 12:07 AM