fnd_set API not working as expected getting ORA-06501: PL/SQL: program error and other errors
Hello All,
Thanks in advance for taking a look at my issue. We are trying to automate the process of cleanup of all existing unwanted programs from our application including references of programs/request sets. Below is the code used for deleting request set from application but it is not working. Please review:
DECLARE
v_old_request_set_short_name VARCHAR2(200);
v_old_request_set_application VARCHAR2(200);
v_old_request_group VARCHAR2(200);
v_old_group_application VARCHAR2(200);
BEGIN
--Initializing the constants needed by all the oracle standard API's
v_old_request_set_short_name := 'CUSTSETUPS'; --P_OLD_REQUEST_SET_SHORT_NAME;