1 New Features

New features for Release 12c (12.2.1.x) of Oracle Technology Adapters are:

  • Beginning in 12c (12.2.1.3): If you want to use the Database Adapter to connect to Oracle Database 18c or later, wrapper generation for user-defined data types used as IN /OUT parameters in a stored procedure is not supported. To bypass the wrapper generation so that you can connect to Oracle Database 18c, you must install the following 12c (12.2.1.3) patches:

    • JDeveloper: 31026573 and 30922431
    • SOA Suite (runtime): 30922431

    After applying the patches, the wrapper bypass means you will need to redesign the stored procedure to use alternative data types if you want to connect to Oracle Database 18c or later. See Support for PL/SQL Boolean, PL/SQL Record, and PL/SQL Table Types in Understanding Technology Adapters.