All posts tagged cloud

Working with Cursors in Oracle PL/SQL

In this article I’ll explain several ways Cursors are used in PL/SQL. For basic details on cursors and its types please refer this blog. There are multiple ways we can…

Read more

Invoke BIP Report with Parameters in OIC

In this article, I’ll develop an app-driven integration that will run an ESS job which invokes a BIP report and map the response to the REST connection. This use case…

Read more

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…

Read more

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…

Read more

How to show a table in a select single component in Oracle Visual builder

In this article, I am going to demonstrate how can we embed a table in a select single component in oracle visual builder. What is the use of showing a…

Read more

Place file in Object Storage from BIP using OIC

In this article, I’ll explain how to use Oracle Integration cloud to place file from BI Publisher report to Object Storage. What is Object Storage It is an internet-scale, high-performance…

Read more

Place file in FTP Server from BIP using OIC

In this article, I’ll explain how to use Oracle Integration cloud to place file from BI Publisher report to FTP server. I’ll develop a scheduled integration that will run a…

Read more

Oracle PL/SQL Cursor: Implicit and Explicit

In this article, I’ll explain cursors and different types of cursors(Implicit and Explicit) with examples. When an SQL statement is processed, Oracle creates a memory area known as the context…

Read more

Creating Procedures, Functions, and Packages in PL/SQL

In this tutorial, you will see a detailed description of how to create and execute the named blocks (procedures and functions and packages). What is a Procedure? A Procedure in PL/SQL is…

Read more

Oracle Integration | format-dateTime() is failing with “The XPath expression failed to execute

While doing the conversion of current date time into another format using the format:dateTime() function into Oracle Integration: you may face the following error: Issue: The issue is the xp20:format-dateTime…

Read more

Oracle Integration Cloud

Oracle Integration Cloud Deep Dive. Learn OIC end to end with real-time examples and earn more in 2021. Apply coupon code “OICLEARN12” to avail discount.

Buy OIC Course

—————————————————————————————————————————

Oracle Visual Builder

Learn Oracle Visual Builder step by step with real-time examples. Apply coupon code “VBCOURSE12” to avail discount.

Buy VBCS Course