My Oracle Support Banner

Invalid PLSQL database packages under ORASSO schema database user ORA-04063: Package Body "Orasso.Wwsso_pstore_private" PL/SQL: ORA-00904 (Doc ID 371367.1)

Last updated on NOVEMBER 07, 2019

Applies to:

Oracle Application Server Single Sign-On - Version 9.0.4 to 10.1.2.0.2 [Release 10gR1 to 10gR2]
Information in this document applies to any platform.
This problem can occur on any platform.
***Checked for relevance on 05-NOV-2019***


Symptoms

After updating SSO schema table which is not identified or known, some ORASSO packages became invalid.

When trying to validate the packages, you get the following:

ORA-04063: Package Body ''Orasso.Wwsso_pstore_private'' 

And, when trying to issue the following select statement, you see the following errors:

SQL> select text from dba_errors where name='WWSSO_PSTORE_PRIVATE';

TEXT
--------------------------------------------------------------------------------

PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "<APP_ID1>": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "<APP_ID1>": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "<APP_ID1>": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "<APP_ID2>": invalid identifier

8 rows selected.

Changes

Some update took place in SSO schema that is not known.  

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.