Run Child integration or PL/SQL procedure in batches in Oracle Integration
In this tutorial, we will see a detailed description of how to run an ATP procedure or a child integration in batches by invoking via OIC. Use case: Let’s say […]
In this tutorial, we will see a detailed description of how to run an ATP procedure or a child integration in batches by invoking via OIC. Use case: Let’s say […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 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, […]