My Oracle Support Banner

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 SEPTEMBER 08, 2021

Applies to:

Oracle Application Express (APEX) - Version 21.1 and later
APEX Application Development - Version NA and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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