PLSQL Archives - Ontoor blogs

Advanced SQL Query Validation: Ensuring Integrity with PL/SQL

In today's data-driven world, ensuring the accuracy and integrity of SQL queries is paramount. Invalid queries can lead to errors, performance issues, and data inconsistencies. This blog will deep into…

Vikas Pandey August 30, 2024

APEX PLUGINS

APEX Font Toggler (AFT)

APEX Font Toggler (AFT) Plugin. APEX Font Toggler (AFT) plugin allow users to increase or decrease application font size at their convenience and this plugin is free for use under…

Vikas Pandey February 12, 2022

APEX PLSQL

How to bulk return in FORALL insert?

BULK Return from FORALL insert. CREATE TABLE ashish_bulk_ret ( id NUMBER GENERATED AS IDENTITY PRIMARY KEY, name VARCHAR2 (31) ); DECLARE TYPE l_rec_typ IS RECORD ( id NUMBER, name VARCHAR2…

Ashish Sahay September 25, 2021

ORACLE PLSQL

PLSQL Collection

PL/SQL provides three collection types − Index-by tables or Associative array Syntax TYPE type_name IS TABLE OF element_type [NOT NULL] INDEX BY subscript_type; table_name type_name; Example TYPE l_tab_type IS TABLE…

Ashish Sahay August 7, 2021

ORACLE PLSQL

CLOB to BLOB using PLSQL

Create function to convert the CLOB to BLOB Copy CodeCopiedUse a different BrowserCREATE OR REPLACE FUNCTION clob_to_blob (i_clob_text IN CLOB) RETURN BLOB IS /* Version 1 29-mar-2020 */ l_blob_file BLOB;…

Ashish Sahay February 29, 2020

ORACLE PLSQL

ORA-06531: Reference to uninitialized collection PLSQL

ORA-06531: Reference to uninitialized collection Error Description:Reference to uninitialized collection Error Cause:An element or member function of a nested table or varray was referenced (where an initialized collection is needed) without…

Ashish Sahay February 25, 2020