Page 1 of 1
TIME Field
Posted: Mon 01 Sep 2008 14:32
by SALEXN
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!
Posted: Tue 02 Sep 2008 08:51
by Plash
Please describe in more details how to create a table with a TIME field.
Posted: Tue 02 Sep 2008 11:29
by SALEXN
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
Posted: Wed 03 Sep 2008 07:54
by Plash
Probably TIME is undocumented data type. If you have some information about this type, please provide us a reference.