BookmarkSubscribeRSS Feed
sathya66
Barite | Level 11

Hi,

Oracle database table has 4 columns , one columns data type is XML .We registered this table in SAS DI but it is registered only with 3 columns not 4. I think it is  because of data type.

how can we overcome this issue.

Thanks

5 REPLIES 5
LinusH
Tourmaline | Level 20

XML is not a supported data type for SAS/ACCESS to Oracle.

You need somehow cast that to another supported data type, perhaps in a Oracle view.

https://documentation.sas.com/?docsetId=acreldb&docsetTarget=p06jk0u30uhuj5n18fqw9sxr25lk.htm&docset...

Data never sleeps
sathya66
Barite | Level 11
Sorry ,it is a oracle view not oracle table
LinusH
Tourmaline | Level 20
Not sure why this would be an issue.
Views can read views in Oracle, right? Or you can create a view that reads the underlying table(s)...?
Data never sleeps
sathya66
Barite | Level 11

Yes, we created a view that reads underlying tables but metadata is not reading that xml type column when we registered. do we need to do any config change.

SASKiwi
PROC Star

@sathya66  - Did you convert the Oracle XML column to character in the Oracle view as advised by @LinusH ?

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 864 views
  • 5 likes
  • 3 in conversation