SnapDBA
  • Home
  • RMAN
  • Database
    • Data Guard
    • Data Pump
    • Performance Tuning
    • Security
    • General
  • Enterprise Manager
    • Grid Control 11g
    • Cloud Control 12c
  • Middleware
    • APEX
    • Application Server
    • Forms & Reports
    • WebLogic Server
  • OS
    • Linux & UNIX
    • Windows
    • VirtualBox
  • SQL Server
  • MongoDB
  • About Me
Home » Posts tagged "hshuid"

Tag Archives: hshuid

PLS-00801: internal error [hshuid:LU invalid] when compiling a package body

Posted on October 25, 2016 by Garth

This was a strange one.  Attempts at recompiling the following package body resulted in this PLS-00801 error. COL owner FOR A20 COL object_name FOR A40 BREAK ON object_name SELECT owner, object_name, object_type, status, created, last_ddl_time FROM dba_objects WHERE object_name = ‘PKG_FINANCIALS_WORK’ ORDER BY status, object_type / OWNER                OBJECT_NAME    

Read More…

Posted in General | Tags: compilation, hshuid, invalid, PLS-00801 | Leave a comment |

Archived

Popular Posts

  • Using SQL Developer to connect to SQL Server databases
  • Oracle Database 11gR2 (11.2.0.4) installation on Oracle Linux 6.4
  • Creating an Oracle 11g Database using DBCA (non-ASM)
  • How to check which PSU is installed...if any
  • Cannot show requested dialog. (SqlMgmt) Property Owner is not available...

External Links

  • SQL Formatter
  • Oracle Live SQL
  • SQL Fiddle
  • ASH Viewer
  • MOS
  • Oracle Forum
  • Oracle Base
  • Oracle FAQ
  • Oracle Articles
  • Rob Zoeteweij’s EM Blog
Copyright © 2018 SnapDBA.com
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OKPrivacy policy