VARCHAR2 Length

VARCHAR2 Length

Postby wjm4 » Tue 27 May 2008 20:06

When looking at a table in my database through Ora Developer Tools. I noticed that the length of all of my varchar2 fields are incorrect. In some cases it even shows the length as 0 which oracle does not even allow. Is there some setting to change to make it not do this? This seems like a bug in the software. I am using oracle 9.2 with the newest version of ora developer tools 2.55.121.0. I can furnish examples if needed. Thanks for the help.
wjm4
 
Posts: 72
Joined: Mon 12 Feb 2007 21:31

Postby Duke » Fri 30 May 2008 07:24

Could you please supply us with following information?
1. NLS parameters of your database (primary and NLS charsets etc)
2. Example of CREATE TABLE statement that gives error in OraDeveloper
Duke
Devart Team
 
Posts: 476
Joined: Fri 29 Oct 2004 09:25

Postby wjm4 » Fri 30 May 2008 12:32

NLS Parameters

DB_PARAM DB_VALUE
------------------------------ ----------------------------------------
NLS_CALENDAR GREGORIAN
NLS_CHARACTERSET UTF8
NLS_COMP BINARY
NLS_CURRENCY $
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_DUAL_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_LANGUAGE AMERICAN
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CHARACTERSET UTF8

DB_PARAM DB_VALUE
------------------------------ ----------------------------------------
NLS_NCHAR_CONV_EXCP FALSE
NLS_NUMERIC_CHARACTERS .,
NLS_RDBMS_VERSION 9.2.0.6.0
NLS_SORT BINARY
NLS_TERRITORY AMERICA
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR


Create Table

-- Script was generated by Core Lab OraDeveloper Tools
-- Script date 5/30/2008 7:02:39 AM
-- Server version: 9.2.0.6.0
-- Client version:


--
-- Definition for table TABLE1
--
CREATE TABLE TABLE1 (
COLUMN1 VARCHAR2(1),
COLUMN2 VARCHAR2(10))
TABLESPACE DATA01
STORAGE (
INITIAL 64K
MAXEXTENTS UNLIMITED
)
NOLOGGING
NOMONITORING;

Once the table is created and I double click the table to open its' properties and I see that column1 is length of 0 and column2 is length of 3
wjm4
 
Posts: 72
Joined: Mon 12 Feb 2007 21:31

Are you working on it?

Postby wjm4 » Mon 09 Jun 2008 21:49

Do you have anything? Any ideas? Are you working on it?
wjm4
 
Posts: 72
Joined: Mon 12 Feb 2007 21:31

Postby Alexz » Tue 10 Jun 2008 14:13

Could you please create TABLE1 and run
Code: Select all
SELECT * FROM sys.user_tab_columns WHERE table_name = 'TABLE1'

Then press the "export data" button in grid with the query result and export all data to HTML. Please, give us that HTML file.
Alexz
Devart Team
 
Posts: 165
Joined: Wed 10 Aug 2005 08:30

HTML

Postby wjm4 » Tue 10 Jun 2008 18:50



expdata


































































































TABLE_NAME COLUMN_NAME DATA_TYPE DATA_TYPE_MOD DATA_TYPE_OWNER DATA_LENGTH DATA_PRECISION DATA_SCALE NULLABLE COLUMN_ID DEFAULT_LENGTH DATA_DEFAULT NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY NUM_NULLS NUM_BUCKETS LAST_ANALYZED SAMPLE_SIZE CHARACTER_SET_NAME CHAR_COL_DECL_LENGTH GLOBAL_STATS USER_STATS AVG_COL_LEN CHAR_LENGTH CHAR_USED V80_FMT_IMAGE DATA_UPGRADED
TABLE1 COLUMN1 VARCHAR2 &nbsp &nbsp 1 &nbsp &nbsp Y 1 &nbsp &nbsp 0 &nbsp &nbsp 0 0 1 6/9/2008 8:25:10 AM &nbsp CHAR_CS 1 YES NO 0 1 B NO YES
TABLE1 COLUMN2 VARCHAR2 &nbsp &nbsp 10 &nbsp &nbsp Y 2 &nbsp &nbsp 0 &nbsp &nbsp 0 0 1 6/9/2008 8:25:10 AM &nbsp CHAR_CS 10 YES NO 0 10 B NO YES


wjm4
 
Posts: 72
Joined: Mon 12 Feb 2007 21:31

Postby Alexz » Wed 11 Jun 2008 09:38

Thanks for the information. It was very useful.
We'll fix this problem in the next build of OraDeveloper.
Alexz
Devart Team
 
Posts: 165
Joined: Wed 10 Aug 2005 08:30


Return to dbForge for Oracle