Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to resolve type

Dik_PATERMar 19 2018 — edited Mar 19 2018

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.

Comments

Oyvind Isene

The first statement for declaring the package is not really relevant, or am I missing something? Anyway, I did this in latest version of SQL Developer against an 11.2.0.4 database without getting any errors:

create or replace type user1_type 
AS OBJECT ( DEMO VARCHAR2(3)) ; 
/
create table nobeer 
( col1 user1_type ) ; 
SELECT * FROM NOBEER ;
1 person found this helpful
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 16 2018
Added on Mar 19 2018
#sql-developer
1 comment
979 views