ColdFusion MX provides only limited support for the Oracle OCI JDBC driver. This TechNote describes the problems with the OCI driver and any workarounds for OCI issues.
Oracle's OCI driver is a Type 2 JDBC driver. It implements the JDBC interface and uses the OCI (Oracle Call Interface) native driver to interact with the database. This requires that you install the Oracle client software on the same machine. Because OCI is not a pure Java JDBC driver (Type 4 drivers are pure Java), it requires Oracle-specific JDBC calls for performing some database operations. These non-standard JDBC calls make the OCI driver not fully compatible with ColdFusion MX.
The following database operations are not supported in ColdFusion MX with the Oracle OCI JDBC driver.