Title
"Exception while configuring SSO Server :ORA-06502: PL/SQL: numeric or value error"

Date
2005-06-06

Summary
If you get this error, following the instructions below to resolve: 
ERROR : Exception while configuring SSO Server :ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "ORASSO.WWSSO_LS_PRIVATE", line 4274
ORA-06512: at "ORASSO.WWSSO_LS_PRIVATE", line 4345
ORA-06512: at line 1

Details
1. Choose your appropriate site before updating: 
UPDATE wwsso_papp_configuration_info$
SET    failure_url = 'https://ssoserver/pls/orasso/orasso.wwsso_app_admin.failure_url'
WHERE  site_token LIKE '%'
AND    failure_url = 'failure_url';

Applicable Versions
Oracle Single Sign-On 9i
Ahmed Aboulnaga
.com .com