ORACLE 'anydata' type

[jplarios]

Hello-
anybody know of a way to read Oracle's 'anydata' type?

[LinusH]

Using the Anydata data type means that you can store data of different types in a single column. Beats my when this comes in handy.

There is no automatic support for this in SAS/ACCESS. To read this data you need to create (if not already exists at your site) wrapper functions to call the appropriate methods that can sort out which data type the actual value is stored. See this blog:

http://www.orafaq.com/node/1853

To this data SAS, I can only guess. You might be able to create a view in Oracle that SAS is able read using the wrapper function. You might even be able to use SQL pass-thru for this. It would be interesting to hear if you could make this work.

Regards,
Linus