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!

Field sizes do not appear in DDL

1979289Jan 31 2014 — edited Feb 2 2014

Despite using this to generate SQL Server data models, when I use domain fields whereby I have specified VARCHAR2(100 CHAR) for example, when I run Export DDL the script is generated with the field sizes missing for Oracle databases (11g). This makes it almost useless.

CREATE TABLE MDWH.PARTITION_KEY

  (

    PARTITION_KEY VARCHAR2 NOT NULL ,

    REPORTING_DATE DATE

  ) ;

CREATE UNIQUE INDEX MUSI_MDWH.PK_PARTITION_KEY ON MUSI_MDWH.PARTITION_KEY

  (

    PARTITION_KEY ASC

  )

  ;

  ALTER TABLE MUSI_MDWH.PARTITION_KEY ADD CONSTRAINT PARTITION_KEY_PK PRIMARY KEY ( PARTITION_KEY ) ;

Comments

I suspect that you have the problem of the pass-through scenario.
Your NLS_LANG and Unicode locale are set to AL32UTF8 but
your terminal works in WE8ISO8859P1. Hence, you can enter
and retrieve your data but they are not stored legal AL32UTF8 codes.
This only suspicion, therefore please do the following test:

INSERT INTO <your_table>(<your_CLOB_COLUMN>)
VALUES( UNISTR('\00e4\00f6\00fc\00df') );

and query this value back. If you correctly see three German lowercase umlauts
and sharp s, then my diagnosis is wrong and I will try again.

Otherwise, set NLS_LANG=.WE8ISO8859P1 and restart your tests.


-- Sergiusz
361551
No, my terminal works with UFT-8 encoding.
I called your SQL-Statement twice, from windows and from UNIX, and I can see these four characters displayed correctly on the both sides.

Dzianis
Please, specify the exact database and client versions.

-- Sergiusz
Also, please post the code fragment that reports the error.

-- Sergiusz
361551
Server and Client have the same version number:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
361551
The OCI function is OCILobRead.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 2 2014
Added on Jan 31 2014
#sql-developer
3 comments
1,630 views