Getting Error: Error in PLSQL Code Raised During Plug-in Processing, When Attempting to Login on APEX, Using IDCS / SSO Authentication (Doc ID 2804411.1)

Last updated on DECEMBER 01, 2023

Applies to:

Symptoms

When attempting to login into an APEX application, the following error occurs.

ERROR
-----------------------
Error in PLSQL code raised during plug-in processing

STEPS
-----------------------
1. Create an IDCS Authentication Scheme
2. Create an IDCS Web Credential
3. In IDCS, users must exist and they must be assigned to group
4. Attempt to login into APEX. IDCS login page will appear instead
5. Set the IDCS credentials and click on Login
6. When attempting to return to APEX, error message will appear

IDCS Authentication Scheme fields are the following:

APEX Debug Trace shows the following:

- error_backtrace: ORA-06512: at line 14
ORA-06512: at line 21
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 685
ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 2263
ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 124
ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 2302
ORA-06512: at line 14
ORA-06512: at line 21
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 685
ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 2263
ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 96
ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 301
ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC", line 340
ORA-06512: at "APEX_200200.WWV_FLOW_AUTHENTICATION", line 2062

- error_statement: begin declare
Procedure load_dynamic_groups as
l_group_names apex_t_varchar2;
begin
--
-- add all group names to l_group_names
--
for i in 1 .. apex_json.get_count('groups') loop
    apex_string.push (
  p_table => l_group_names,
  p_value => apex_json.get_varchar2 (
                 p_path => 'group[%d].name',
 p0     => i));
end loop;
--
-- save group names in session
apex_authorization.enable_dynamic_groups (
    p_group_names => l_group_names );
end;
begin
load_dynamic_groups;
end;
end;

- component: APEX_APPLICATION_AUTH IDCS Authentication Scheme

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.