ODBC and PL/SQL
231177Nov 28 2003 — edited Dec 3 2003Can 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