Timestamp scale not preserved

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Lu53
Posts: 6
Joined: Fri 25 Jul 2008 23:13

Timestamp scale not preserved

Post by Lu53 » Mon 22 Feb 2010 14:13

A table field declared as e.g.

TESTFIELD TIMESTAMP(3)

when loaded into the table editor loses its scale and becomes

TIMESTAMP(0)

Even when changing scale back to 3 with the field editor, it keeps being displayed as 0, although stored in the DB correctly.

Unfortunately, when doing a DDL extract of the table, the scale is again back to 0, making it impossible to use DDL extracted SQL files with any table that contains timestamps, because all timestamp scales are rendered to 0.

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Mon 22 Feb 2010 16:12

We failed to reproduce this error.
Tell us the version of OraDeveloper Studio that you are using.
Tell us the version of ORACLE server that you are using.

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Tue 23 Feb 2010 12:04

Finally we have reproduced this error.
Please wait for a new build with the fix.

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Tue 02 Mar 2010 16:54

Scale for columns with data type as TIMESTAMP retrived without errors now!
Please download the recent version of the product.
The latest version is 2.55.167 (02-Mar-2010).

Post Reply