Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    Germany
    Posts
    11

    Unanswered: calling a PL-SQL procedure in php

    hi !

    i have an incomprehensible problem. i wrote a php-page, in which i want to insert data to an oracle-database. if i use the insert-statement => no problem.
    i want to check the data using a procedure, so i wrote a procedure and call this procedure (giving the procedure the parameters) from php => failure.
    in sql+ the procedure works without problems.
    i get the following message:

    Warning: Ora_Parse failed (ORA-00900: invalid SQL-statement -- while processing OCI function OPARSE)

    i use php version 4.0.6.
    can anyone help me?

    thanks so far
    susi

  2. #2
    Join Date
    Oct 2002
    Location
    Germany
    Posts
    11

    Smile roman and susi found the solution ...

    ... at google groups:

    ora_parse ="begin function_name('var1', 'var2'); end;";

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •