https://communities.sas.com/t5/SAS-Programming/ORACLE-anydata-type/m-p/48692#M10056 Hello-<BR /> anybody know of a way to read Oracle's 'anydata' type? Tue, 12 Apr 2011 19:46:30 GMT jplarios 2011-04-12T19:46:30Z https://communities.sas.com/t5/SAS-Programming/ORACLE-anydata-type/m-p/48692#M10056 Hello-<BR /> anybody know of a way to read Oracle's 'anydata' type? Tue, 12 Apr 2011 19:46:30 GMT https://communities.sas.com/t5/SAS-Programming/ORACLE-anydata-type/m-p/48692#M10056 jplarios 2011-04-12T19:46:30Z https://communities.sas.com/t5/SAS-Programming/ORACLE-anydata-type/m-p/48693#M10057 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.<BR /> <BR /> 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:<BR /> <BR /> <A href="http://www.orafaq.com/node/1853" target="_blank">http://www.orafaq.com/node/1853</A><BR /> <BR /> 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.<BR /> <BR /> Regards,<BR /> Linus Wed, 13 Apr 2011 13:40:39 GMT https://communities.sas.com/t5/SAS-Programming/ORACLE-anydata-type/m-p/48693#M10057 LinusH 2011-04-13T13:40:39Z