ORA-04063: view/package … has errors

ORA-04063: view … has errors

create table tq84_tab (
   num   number,
   txt   varchar2(10)
);


create or replace view tq84_view as
select
   t.num,
   t.txt,
   t.unobtanium
from
   tq84_tab t;
--
-- Warning: View created with compilation errors.
--

select * from tq84_view;
--
-- ORA-04063: view "RENE.TQ84_VIEW" has errors
--

select
   text
from
   user_errors
where
   type = 'VIEW'       and
   name = 'TQ84_VIEW';
--
-- ORA-00904: "T"."UNOBTANIUM": invalid identifier
--

ORA-04063: package body … has errors

create or replace package tq84_ora_04063_pkg
   authid definer
as
   function f return number;
end tq84_ora_04063_pkg;
/

create or replace package body tq84_ora_04063_pkg  as
    this package has errors!
end tq84_ora_04063_pkg;
/
--
-- 2/18      PLS-00103: Encountered the symbol "HAS" when expecting one of the following:     := . ( @ % ; not null range default character 
--
 
create or replace view tq84_ora_04063_view as
select
   tq84_ora_04063_pkg.f
from
   dual;
--
-- View TQ84_ORA_04063_VIEW created.
--
  
select * from tq84_ora_04063_view;
-- ORA-04063: package body "RENE.TQ84_ORA_04063_PKG" has errors

See also