topic Re: XML Data type issue in metadata table in Administration and Deployment

XML Data type issue in metadata table

sathya66 — Thu, 20 Aug 2020 13:23:12 GMT

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

Re: XML Data type issue in metadata table

LinusH — Thu, 20 Aug 2020 13:23:57 GMT

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&docsetVersion=9.4&locale=en

Re: XML Data type issue in metadata table

sathya66 — Thu, 20 Aug 2020 13:28:42 GMT

Sorry ,it is a oracle view not oracle table

Re: XML Data type issue in metadata table

LinusH — Fri, 04 Sep 2020 12:43:43 GMT

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)...?

Re: XML Data type issue in metadata table

sathya66 — Wed, 09 Sep 2020 08:01:02 GMT

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.

Re: XML Data type issue in metadata table

SASKiwi — Thu, 10 Sep 2020 00:45:35 GMT

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