4 Replies Latest reply on Mar 13, 2014 1:39 AM by SandraZhou-Oracle

    Sql Devloper 4.0.0.13 - problems with displaying user data types

    OmerGe

      Hi,

       

      I have installed new version of sqldeveloper and have discovered some problems with displaying user data types. The data that is described as VARCHAR2 are displayed with ‘???’.

      The problem persist in table view, script output and exported files.

       

      My type is described as follows:

      create or replace TYPE "DPTY_ADRESA" AS OBJECT

      (

        ID_DPSF_OPCINE                                         NUMBER,

        ID_DPSF_MJESTA                                        NUMBER,

        OPCINA                                            VARCHAR2(100),

        MJESTO                                            VARCHAR2(100),

        ULICA                                 VARCHAR2(200),

        BROJ                                   VARCHAR2(20),

        SPRAT                VARCHAR2(20),

        OSTALO                             VARCHAR2(100),

        CONSTRUCTOR FUNCTION dpty_adresa RETURN SELF AS RESULT

      )

      add MEMBER FUNCTION dajAdresu RETURN VARCHAR2 cascade;

       

      when make select column from table that contains this type I get next results:

       

      CASE 1:

      SQLDeveloper Version 3.2.20.09; Build MAIN-09.87; JDK 1.6.0_43; Windows 7 64 bit

       

      Select:

      select id, adresalokacija

      from dptr_saglasnosti

      where id = 1;

       

      Result:

              ID ADRESALOKACIJA

      ---------- --------------------------------------------------------------------------------------------------------

               1 COMP.DPTY_ADRESA(124,4913,'TRAIK','TURBE','BABANA','3452','0',NULL)

       

      END CASE 1;

       

      CASE 2:

       

      SQLDeveloper Version 4.0.0.13; Build MAIN-13.80; JDK 1.7.0_40; Windows 7 64 bit

      Select1:

      select id, adresalokacija

      from dptr_saglasnosti

      where id = 1;

       

      Result1:

      ID ADRESALOKACIJA

      ---------- --------------------------------------------------------------------------------------------------------

               1 COMP.DPTY_ADRESA(124,4913,'???','???','???','???','???',NULL)    

       

      But if I select one element it is displayed normal.

       

      Select2:

      select id, a.adresalokacija.opcina

      from dptr_saglasnosti a

      where id = 1;

       

      Result2:

      ID ADRESALOKACIJA.OPCINA

      ---------- -------------------------------------

               1 TRAVNIK                  

       

      END CASE 2;

       

      I have tried this scenario on three different pc with same output.

      Pleas help me to get rid of the '???' in result.

       

      Best Regards,

      Omer

        • 1. Re: Sql Devloper 4.0.0.13 - problems with displaying user data types
          SandraZhou-Oracle

            I tried on SQLDeveloper Version 4.0.0.13; Build MAIN-13.80; JDK 1.7.0_45; Windows 7 64 bit; NLS setting is default

          all data can show,No ??? in result

          Test step as following:

          create or replace TYPE "DPTY_ADRESA" AS OBJECT

          (

            ID_DPSF_OPCINE                                         NUMBER,

            ID_DPSF_MJESTA                                        NUMBER,

            OPCINA                                            VARCHAR2(100),

            MJESTO                                            VARCHAR2(100),

            ULICA                                 VARCHAR2(200),

            BROJ                                   VARCHAR2(20),

            SPRAT                VARCHAR2(20),

            OSTALO                             VARCHAR2(100),

            CONSTRUCTOR FUNCTION dpty_adresa RETURN SELF AS RESULT

          );

          alter TYPE "DPTY_ADRESA" add MEMBER FUNCTION dajAdresu RETURN VARCHAR2 cascade;

           

          CREATE TABLE dptr_saglasnosti (

          adresalokacija        DPTY_ADRESA,

            id    number);

           

            INSERT INTO dptr_saglasnosti VALUES (

            DPTY_ADRESA (65,225,'Vrinda Mills', '1-800-555-4412','sss','aaaa','eeeee','attta'),1 );

           

          select id, adresalokacija from dptr_saglasnosti where id = 1;

          ID ADRESALOKACIJA

          ---------- --------------------------------------------------------------------------------------------------------

          1    HRCP.DPTY_ADRESA(65,225,'Vrinda Mills','1-800-555-4412','sss','aaaa','eeeee','attta')

          • 2. Re: Sql Devloper 4.0.0.13 - problems with displaying user data types
            SandraZhou-Oracle

            if  NLS_CHARACTERSET  is  CL8MSWIN1251 ,The ??? shows, If NLS_CHARACTERSET  is  WE8MSWIN1252,all data show normally, You can try to  change the character set

            • 3. Re: Sql Devloper 4.0.0.13 - problems with displaying user data types
              OmerGe

              Hi Sandra,

               

               

              First of all take my apologize for the very late reply.

              Unfortunately, after I published post I had eye surgery. I have just returned to work.

               

               

               

              Thanks for your answers and efforts. Unfortunately they did not help to me.

               

               

              I just downloaded new version of SQL Developer ( 4.0.1.14) in  hope that the problem will disappear, but it is still there

               

               

              My nls_charset is EE8MSWIN1250.

              It should be noted that this problem is not present in the earlier version of SQL Developer (3.2.20.09, Build MAIN-09.87).

               

               

               

              Thanks one more time.

               

               

              best regards,

              Omer

              • 4. Re: Sql Devloper 4.0.0.13 - problems with displaying user data types
                SandraZhou-Oracle

                HI OmerGe,

                Raised bug18016926 about the issue

                Thanks and Regards

                1 person found this helpful