My Oracle Support Banner

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 OCTOBER 10, 2023

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.

Goal

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

exec wwsec_api.add_user_to_list(wwsec_api.id_sso('<HOSTNAME>'),
wwsec_api.group_id('My Group Name'), 0);

BEGIN wwsec_api.add_user_to_list(wwsec_api.id_sso('<HOSTNAME>'),
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

To view full details, 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 a vibrant support community of peers and Oracle experts.