Importing IAR File Not Creating Pl/sql Objects
Last updated on AUGUST 16, 2017
Applies to:Integration Cloud Service - Version N/A and later
Information in this document applies to any platform.
invoke to call a DB procedure. When IAR file initially getting created and goes through the invoke wizard, it creates the necessary ics wrapper type and package in the database.
But if the iar gets exported, and imported into new environment, the ics warpper pl/sql type and packages are not getting created. To get the wrapper PL/SQL objects created, Customer needs to open the invoke in integration and go through the wizard to get the type and package created
The issue can be reproduced at will with the following steps:
1. Create an Integration to invoke DB PL/SQL
2. Export the iar file and delete all the pl/sql objects created before.
3. Reimport the iar file and note pl/sql objects not getting created.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms