How To Debug Unhandled User-Defined Exceptions Generated From Calls To Portal PL/SQL APIs - eg Errors Like ORA-06510, ORA-06512 (Doc ID 821747.1)

Last updated on MARCH 08, 2017

Applies to:

Portal - Version 10.1.2.0.2 to 11.1.1.6.0 [Release 10gR2 to FMW11g]
Information in this document applies to any platform.
Checked for relevance on 21-Nov-2014

Goal

How can the following errors be resolved when using Portal APIs?

exec wwsec_api.add_user_to_list(wwsec_api.id_sso('ABC@XYZ.COM'),
wwsec_api.group_id('My Group Name'), 0);

BEGIN wwsec_api.add_user_to_list(wwsec_api.id_sso('ABC@GOOGLE.COM'),
wwsec_api.group_id('My Group Name'), 0); END;

*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWSEC_API", line 1865
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1



Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms