PDA

View Full Version : calling a PL-SQL procedure in php


susi
10-24-02, 11:21
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

susi
10-28-02, 03:30
... at google groups:

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