Here in this article I will be writing how to read a CLOB file using DBMS_LOB which is more than 32kb size. The below example… Read More »PL/SQL Script to read CLOB(XML Data) which is more than 32kb size
DECLARE lc_role_name apps.wf_roles.name%TYPE := ‘XX_TEST_ROLE’; BEGIN wf_directory.setadhocroleexpiration(lc_role_name, sysdate -1 ); COMMIT; wf_directory.setadhocrolestatus( lc_role_name, ‘INACTIVE’); COMMIT; wf_directory.deleterole(lc_role_name , ‘WF_LOCAL_ROLES’ , 0); COMMIT; END; /DECLARE lc_role_name apps.wf_roles.name%type… Read More »PL/SQL Script to Inactive and Delete Adhoc Role
Before reading this article, read about Roles in Workflow if you are not aware of what a role is about. A role can be created… Read More »Adhoc Roles in Oracle Workflow
DECLARE ln_role_users_count NUMBER; lc_role_name apps.wf_roles.NAME%TYPE := ‘XX_TEST_ROLE’; BEGIN —————————— –Checking if Adhoc Role Exits —————————— SELECT COUNT (1) INTO ln_role_users_count FROM apps.wf_user_roles WHERE NAME =… Read More »PL/SQL Script to Remove and Add Users to Adhoc Role
DECLARE ln_role_count NUMBER; lc_role_name apps.wf_roles.NAME%TYPE := ‘XX_TEST_ROLE’; lc_role_display_name apps.wf_roles.description%TYPE := ‘XX Test Role’; BEGIN —————————— –Checking if Adhoc Role Exits —————————— SELECT COUNT (1) INTO… Read More »PL/SQL Script to Create Adhoc Role
Like any other data type in oracle, even DATE data type has a length restriction. A Date data type can hold a maximum data of… Read More »Date Range in Oracle – Minimum Possible Date and Maximum Possible Date
/********************************************************* *PURPOSE: Sample Usage of PL/SQL Collections * *AUTHOR: Shailender Thallam * **********************************************************/ SET serveroutput ON; DECLARE ——————– –Record type object ——————– TYPE emp_type IS… Read More »Usage of PL/SQL Collections
It would be tiresome for most of us to debug issues especially in extensions when we have no clue of flow of process execution and… Read More »How to Generate Debug Logging for Custom Extensions
Before understanding about BULK COLLECT, lets see how a PL/SQL code is executed. Oracle uses two engines to process PL/SQL code. All procedural code is… Read More »What is BULK COLLECT? How and Why do we need to use it?
Click on the question to see the answer Basic PL/SQL Interview Questions Difference between Syntax and Runtime errors in PL/SQL?? Explain what is… Read More »Top PL/SQL Interview Questions with Answers