How To Call DB Procedure Asynchronously From OIC
In this article, I’ll demonstrate how to call DB procedure asynchronously from OIC and the steps involved in the process. Prerequisites Oracle Integration Cloud Instance ATP DB Call Time limit […]
Load data in ATP from SFTP using OIC – Performance Enhancement
Loading data from a flat file coming from SFTP/BI Publisher or any third party source is a very common requirement for many of the integration. The traditional way for achieving […]
Load data in ATP from BIP using OIC
In this article, I’ll develop a scheduled integration that will run a BIP report in fusion and insert the data from the file in the ATP table. This use case […]
Error and Exception Handling In Oracle PL/SQL
In this article, I’ll demonstrate how your Oracle PL/SQL programs can use errors and exception handlers in Oracle and how to write exception handlers to handle exceptions. PL/SQL exception and […]
Different types of Loops in Oracle PL/SQL
In this article, I’ll demonstrate the different types of loops used in Oracle PL/SQL. Loops are used to repeatedly execute code until some condition is met. We will understand by […]
Creating schema and adding roles in an Oracle Autonomous Database
In this article, I’ll point out the difference between schema and users and also explain how to create a user and add roles to a user in an autonomous database […]
How to provision an Autonomous Database on the Oracle Cloud
In this article, I’ll demonstrate how to provision a free-tier autonomous database instance and the steps involved in it. What is Autonomous Database An autonomous database is a cloud database […]
Oracle Autonomous Transaction Processing Adapter in OIC
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 […]
Oracle Autonomous Transaction Processing instance provisioning
Oracle Autonomous Transaction Processing delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet demands of a variety of applications: mission-critical transaction processing, mixed transactions and analytics, […]