XML Data type issue in metadata table

[sathya66]

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

[LinusH]

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

[sathya66]

Sorry ,it is a oracle view not oracle table

[LinusH]

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

[sathya66]

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]

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