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)