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 […]
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 […]
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 […]
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 […]
![The “MOVE[NOOP][IO_ONLY]” IO operation for “/test/Emp_1.csv” failed: Oracle Integration File adapter](https://www.techsupper.com/wp-content/uploads/2022/08/MOVENOOPIO_O-min-570x570.jpg)
The “MOVE[NOOP][IO_ONLY]” IO operation for “/test/Emp_1.csv” failed: Oracle Integration File adapter
I had a hard time fixing the error The “MOVE[NOOP][IO_ONLY]” IO operation for “/test/archive/Emp_1.csv failed” which occurred while performing the move operation of File adapter in Oracle Integration. The complete […]
Create a Web/Mobile Application in Oracle APEX
In this blog, we will discuss how to build an application in APEX which can be accessed from both Desktop & Mobile. Gone are the days when we used to […]
Service Integration Account with No Password Expiration in OIC
In most cases, you authenticate your custom Oracle Integrations using Basic Authentication and for this, you create a username/password in the Oracle IDCS and grant a certain role(ServiceUser, ServiceInvoker, etc.) […]
Working with a Pie chart in Oracle Visual Builder
In this article, I am demonstrating how to work with a Pie Chart in Oracle Visual Builder. Typically, Pie charts are used to show the relationship between parts and whole […]
BASE64Decoder: Error in encoded stream: Oracle Integration
While mapping the streamReference to opaque element in Oracle Integration you might get the “BASE64Decoder: Error in encoded stream: needed at least 2 valid base64 characters, but only got 0 […]