Not able to read SDO_geometry() datatype in DataStage

[informdaya@gmail.com]

Hi All,
I am not able to read SDO_geometry() datatype[oracle source] in DataStage through ODBC Connector stage.

I am getting the following error.
"An exception occured while trying to receive the response from handler :An exception received from handler:unknown datatype" when try to view data.

i have tried with varchar , longvarchar and longnvarchar but no progress.

Please assist.

[ray.wurlod]

Try using an explicit CAST in the SELECT statement to force the database to deliver you a LONG VARCHAR.

[informdaya@gmail.com]

I have tried with
CAST(<string_or_column> AS <DATATYPE>)
TO_CHAR(<string_or_column>, <format>) and
TO_CLOB(right VARCHAR2 CHARACTER SET ANY_CS) RETURN CLOB

If you have different opinion,just let me know.

[chulett]

What kind of "reading" are you trying to do here? And then what would your target be? Any of these special data types can't be simply selected but are accessed via 'spatial queries' or methods like Get_WKT (get well known text) to return a CLOB.

Details are here.