ORA-06550 error when attempting to run the Data_Retention_Pkg in RSA Identity Governance & Lifecycle
Originally Published: 2018-05-18
Last Modified: 2022-06-20
Article Number
Applies To
RSA Version/Condition: 7.0.2, 7.1.x
Issue
Error starting at line : 1 in command -
BEGIN Data_Retention_Pkg.Prune_Run_Details(SYSDATE-90); END;
Error report -
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DATA_RETENTION_PKG.PRUNE_RUN_DETAILS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
The same error occurs in Oracle SQL*Plus:
$ sqlplus avuser/<password>
SQL> EXECUTE Data_Retention_Pkg.Prune_Run_Details(SYSDATE-90);
BEGIN Data_Retention_Pkg.Prune_Run_Details(SYSDATE-90); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DATA_RETENTION_PKG.PRUNE_RUN_DETAILS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL>
Cause
Resolution
For more information on managing the size of the RSA Identity Governance & Lifecycle Oracle database, please see RSA Knowledge Base Article 000038168 -- How to manage database growth in RSA Identity Governance & Lifecycle.
Related Articles
"BufferOverflowException" when attempting to authenticate to RSA Via Lifecycle and Governance console 102Number of Views XML Parsing Error when attempting SP-initiated Single Sign-On with RSA SecurID Cloud Authentication Service 229Number of Views RSA Identity Governance & Lifecycle XARecoveryModule generates an XAException when attempting to roll back changes in fail… 286Number of Views "Tokencode is incorrect" while attempting to resynchronize an RSA SecurID software token on RSA Authentication Manager 8.x 185Number of Views 'Error bash: service: command not found' error when attempting to stop or start RSA Identity Governance & Lifecycle 87Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?