VARCHAR2 Length

wjm4 · Post by **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.

Duke · Post by **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

wjm4 · Post by **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 · Post by **wjm4** » Mon 09 Jun 2008 21:49

Do you have anything? Any ideas? Are you working on it?

Alexz · Post by **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.

wjm4 · Post by **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

Alexz · Post by **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.