2 Replies Latest reply: Oct 26, 2012 2:35 AM by 774758 RSS

    Errore(7,19): PLS-00201: identifier 'DBMS_CRYPTO' must be declared


      I inherited the management of an Oracle database Standard Edition on a 32 bit Microsoft Windows Server 2003 R2 platform
      with some invalided objects related to SYSMAN schema.
      I suppose that probably these invalid objects are derived from a bad **previous upgrading operation*(probably from to
      Furthermore I looked for a solution on the net and I found that this trouble could be issued dropping and recreating again the Database Control Repository using emca plus specific commands.http://www.idevelopment.info/data/Oracle/DBA_tips/Enterprise_Manager/OEM_3.shtml#On Windows Systems
      I followed these commands on my test database and the repository was successfully created and all the previous invalidated objects where corrected.

      However there is still a view not functioning. I tried to compile it again after the creation of the new Database Control Repository with the command alter view <viewname> compile but it returns the following errors:

      Progetto: sqldev.temp:/IdeConnections%23jhoray01XDB.jpr

      Errore(7,3): PL/SQL: Statement ignored

      Errore(7,19): PLS-00201: identifier 'DBMS_CRYPTO' must be declared

      As I urge to give back the database without invalid objects I would appreciated any helps

      Thanks in advance

      Susy OCP 10G DBA