An example of this error is:
SQL> select * from table [S1000][unixODBC][Easysoft][Oracle]Unable to map datatype( 108 ) for column ( 1 ) [ISQL]ERROR: Could not SQLPrepare
The datatype 108 is the Oracle internal type "user defined type". The Easysoft ODBC-Oracle Driver cannot map user defined types itself, although you can modify your SQL to work around this.
For example, if you have a table with the predefined user defined type "XMLTYPE", you cannot directly select this column from the table -- you get the error shown above. However, if you use the functions getClobVal
or getStringVal
, you can obtain your user defined type column:
select alias.column.getClobVal() from table alias
Note This only works if you use a table alias.