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.
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.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.