DATA Step, Macro, Functions and more

ORACLE 'anydata' type

Reply
Regular Contributor
Posts: 163

ORACLE 'anydata' type

Hello-
anybody know of a way to read Oracle's 'anydata' type?
Super User
Posts: 5,257

Re: ORACLE 'anydata' type

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
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 129 views
  • 0 likes
  • 2 in conversation