1 Reply Latest reply on Mar 19, 2018 7:55 AM by Oyvind Isene

    Unable to resolve type

    Dik_PATER

      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.

        • 1. Re: Unable to resolve type
          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 ;