If you have a user called for instance USER1
and you create a package for instance USER1
CREATE OR REPLACE
PACKAGE USER1 AS
function f_demo
return varchar2;
END USER1;
create or replace type user1_type
as object ( demo varchar2(3)) ;
create table nobeer
( col1 user1_type ) ;
select * from nobeer ;
Gives :
Maken van descriptor is mislukt.: Unable to resolve type "USER1.USER1_TYPE"
select count(*) from nobeer ;
is without error.
FROM SQL*PLUS everything works ok !
We solved this by renaming the package BTW.
So this is not a problem for us.
Regards
Dik Pater.