Errors in converting column / Oracle type (ArcSDE log)

Question

We are getting following errors in our ArcSDE 9.2 SP6 (sorry, had a typo!) on Oracle 10gR2 DBMS log file, have no idea what they mean:

Any suggestions, ideas for its causes or what to analyze to get more clues what is going on?
db_map_dbms_to_sde_type::Error in converting Oracle type = 188
db_describe_select::Error converting column 8
db_map_dbms_to_sde_type::Error in converting Oracle type = 23
db_describe_select::Error converting column 9
db_map_dbms_to_sde_type::Error in converting Oracle type = 8
db_describe_select::Error converting column 12
db_map_dbms_to_sde_type::Error in converting Oracle type = 8
db_describe_select::Error converting column 3
db_map_dbms_to_sde_type::Error in converting Oracle type = 188
db_describe_select::Error converting column 6
db_map_dbms_to_sde_type::Error in converting Oracle type = 23
db_describe_select::Error converting column 3
db_map_dbms_to_sde_type::Error in converting Oracle type = 187
db_describe_select::Error converting column 4
db_map_dbms_to_sde_type::Error in converting Oracle type = 23
db_describe_select::Error converting column 58
db_map_dbms_to_sde_type::Error in converting Oracle type = 190
db_describe_select::Error converting column 2

DejanGregor · Answer

Hi Vincent,

you are wonderful! Thank you, you pointed me on the right direction.

Cheers,
Dejan

VinceAngelo · Answer

I found the magic search term that led me to the right directory for OCI include files:
  8 = SQLT_LNG             /* long */
23 = SQLT_BIN             /* binary data(DTYBIN) */
187 = SQLT_TIMESTAMP     /* TIMESTAMP */
188 = SQLT_TIMESTAMP_TZ /* TIMESTAMP WITH TIME ZONE */
190 = SQLT_INTERVAL_DS  /* INTERVAL DAY TO SECOND */

So, we've got two generic binary types and three time types with no mapping to the
supported ArcSDE type list.
 
You may be able to use a customized view to remap those types to something that
ArcSDE will know how to decode.
 
- V

DejanGregor · Answer

Hi Vince,

I will do the testing with the 'sdetable -o describe' command and report back. It is running on Oracle 10.2.0.3 with patch 27 on Unix (sun Solaris). ArcSDE is 9.2 with SP6.

Thanks!
Dejan