Limitations

Driver	Database/ Adapter IS Operating System/ Platform Affected	Limitation Description
Oracle JDBC OCI Driver Oracle JDBC Thin Driver	All supported Oracle databases	The NUMBER and NUMBER(n,m) Oracle data types map to java.math.BigDecimal in all the adapter services by default. BLOB and CLOB data types cannot be used in a table definition when configuring the adapter notifications.
Oracle JDBC OCI Driver	Oracle 8.0.5	When mapping a date data type to java.util.Date using the InsertSQL adapter service, you receive the following error: ORA-1024 Invalid data type in OCI call. As a workaround, map the date to java.sql.Timestamp. When connecting to an Oracle 8.0.5 server using the OCI driver and trying to Insert BLOB and CLOB data types, you receive the following error: ORA-01461: can bind a LONG value only for insert into a LONG column.
Oracle JDBC OCI Driver Oracle JDBC Thin Driver	HP-UX 11i	Be sure to apply the HP-UX 11i Quality Pack (June 2002) and the PHSS_26138 on HP-UX 11i before configuring the adapter connection using an OCI driver; otherwise, you receive the following error: Unresolved symbol :gethrtime (code).
Oracle JDBC OCI Driver Oracle JDBC Thin Driver	HP-UX	If all the adapter notifications are enabled for more than 18 hours, you receive the following error: OCI-21503: program terminated by fatal error OCI-04030: out of process memory when trying to allocate 20056 bytes.
Oracle JDBC OCI Driver classes12 Oracle 8i, 9i, 10g, and 11g JDBC Thin Driver	All supported Oracle databases	StoredProcedureWithSignature services and StoredProcedureNotificationWithSignature notifications do not work with Stored Procedures containing a parameter of type Oracle Cursor, when the ref cursor is declared as a cursor type that is defined as a strong type with the %ROWTYPE attribute. The workaround is to define the ref cursor as a weak type.
Oracle JDBC Thin Driver 9.0.1 (Mac OS ) Oracle JDBC OCI Driver Oracle JDBC Thin Driver (all other OSs) DataDirect driver shipped with Host Integration Server	Oracle 10g	With Oracle Database 10g, you cannot configure adapter services or notifications with BINARY_DOUBLE or BINARY_FLOAT databases using the Adapter Service Editor. In these cases, if you try to insert a row, the corresponding JDBC data type does not appear in the Adapter Service Editor. As an alternative, use the CustomSQL adapter service when configuring services involving these data types.