Oracle Autonomous Transaction Processing Adapter in OIC by Ankur Jain
April 19, 2020 Leave a comment
The Oracle Autonomous Transaction Processing Adapter enables you to integrate the Oracle Autonomous Transaction Processing database with Oracle Integration through use of direct connectivity. Use the Oracle Autonomous Transaction Processing Adapter to execute SQL queries or stored procedures in the Oracle database.
In this article, we are going to explain capabilities of ATP adapter and how to connect to Autonomous Transaction Process(ATP) in Oracle Integration Cloud(OIC) using OOTB Oracle ATP adapter.
In my earlier article, I have explained how to provision the Autonomous Transaction Process(ATP) instance. Kindly see the article, before you go ahead in this article.
Capabilities of Oracle Autonomous Transaction Processing Adapter
- Support for using direct connectivity to connect to the Oracle Autonomous Transaction Processing database in place of using the on-premises connectivity agent.
- Support for invocation of stored procedures in the Oracle database
- Support for non-JDBC (PL/SQL record and PL/SQL table) datatypes in outbound invocations of stored procedures
- Support for execution of DML statements and SQL queries: Select, Insert, Update, and Delete. Read the complete article here.
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.
Blog 
Twitter 
LinkedIn ![image[7][2][2][2]](https://soacommunity.files.wordpress.com/2013/04/image7222.png?w=20&h=20 "image[7][2][2][2]"){kind=small}
Facebook ![clip_image002[8][4][2][2][2]](https://soacommunity.files.wordpress.com/2013/04/clip_image00284222.jpg?w=26&h=23 "clip_image002[8][4][2][2][2]"){kind=small}
Wiki
Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress
About Jürgen Kress
PaaS Community Blog 