stored procedure from php

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • cool_dude7244@yahoo.com

    stored procedure from php

    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($curs or,$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

Working...