Easysoft ODBC-Oracle Driver

Why do I get error "Unable to map datatype"?

Article:
00836
Last Reviewed:
4th January 2024
Revision:
1

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.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)