Oracle Database Cloud Service Adapter Restrictions

Note the following Oracle Database Cloud Service Adapter restrictions in Oracle Integration.

  • For direct connections (configured without using the connectivity agent), the Oracle Database Cloud Service Adapter can only be used for making outbound invocations as an invoke connection. This type of Oracle Database Cloud Service Adapter-specific connection cannot be configured as a trigger connection in an integration. Use cases related to inbound polling must be implemented using the scheduled orchestration integration pattern.
  • The PL/SQL boolean type is not supported as an IN/OUT parameter in a stored procedure if the target database is version 18c or higher. However, you can create a wrapper stored procedure that converts a PL/SQL boolean type to an integer and uses that wrapper stored procedure in Oracle Integration.
  • The nested PL/SQL type (for example, a RECORD type inside a TABLE type) is not supported as an IN/OUT parameter in a stored procedure if the target database is version 18c or higher. However, you can define OBJECT types inside TABLE types.