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

Easysoft ODBC-Oracle Driver

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

Article :	00836
Last Reviewed :	19th July 2005
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

Products
- Easysoft ODBC-Oracle Driver

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft ODBC-Oracle Driver

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

Applies To

Knowledge Base Feedback