Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC and PL/SQL

231177Nov 28 2003 — edited Dec 3 2003
Can anyone tell me why the Oracle client (OCI) that sits behind the Oracle ODBC driver, does NOT support PL/SQL?

When I use the Oracle ODBC driver, and try to create a trigger or a stored procedure, I get an error that it was compiled with errors. If I use an ODBC driver like Data Direct that by-passes OCI, the same code works perfectly well (as it does if run through SQL*Plus).

It amazes me that the Oracle OCI does not support Oracle syntax! Or am I doing something wrong?

Regards,
Lee
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2003
Added on Nov 28 2003
8 comments
866 views