TIME Field

SALEXN · Post by **SALEXN** » Mon 01 Sep 2008 14:32

Oracle DB has some TIME field (not TIMESTAMP or DATE field).
These fields created after using following SQL:
"alter session set events '10407 trace name context forever, level 1'".

When I try to open query I get error "Unsupported field type". How I can use TIME field via ODAC Query?

Thanks!

Plash · Post by **Plash** » Tue 02 Sep 2008 08:51

Please describe in more details how to create a table with a TIME field.

SALEXN · Post by **SALEXN** » Tue 02 Sep 2008 11:29

Plash wrote:Please describe in more details how to create a table with a TIME field.

1. After connect to database execure following script:
alter session set events '10407 trace name context forever, level 1'
2. CREATE TABLE t1 (ID NUMVER(9), TIME_FIELD TIME)

If you want to use this field in your scripts you must ALWAYS run the following statement after connect
alter session set events '10407 trace name context forever, level 1'
On other case you get the Oracle exception
ERROR at line 1:
ORA-00902: invalid datatype
Regards, Alex

Plash · Post by **Plash** » Wed 03 Sep 2008 07:54

Probably TIME is undocumented data type. If you have some information about this type, please provide us a reference.