{{theTime}}

Search This Blog

Total Pageviews

ORA-04063 - Re-compiling PL/SQL procedures and packages


The ORA-04063 error is caused when a PL/SQL procedure of package becomes invalid after a change to a subordinate procedure or a schema (table) change.
ORA-04063: package body "name" has errors
Recompile the packages to resolve this error.
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...