Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> oci calling PL/SQL procedure
Is there any special considerations to keep in mind
when calling a PL/SQL procedure from an OCI-program?
We wrote a wrapper above oci 4-5 years ago, and it works fine for SELECT, UPDATE, INSERT and DELETE-statements, but we've never tried to execute PL/SQL-procedures before.
Now we need to do that, and from the documentation I see that it should be possible.
But I get a 'ORA-00900: invalid SQLstatement' message.
We do have the Procedural Option installed,
and the
EXECUTE priceUpdate
statement works in SQL*Worksheet.