https://communities.sas.com/t5/SAS-Procedures/how-to-convert-oracle-clinical-views-to-sas-data-sets/m-p/42894#M11188 First try to find out where the problem is.<BR /> Try to logon to Oracle through a non-SAS connection, using the same user/schema, and try to query the same view. <BR /> If this works, open a track to SAS support and attach a full LOG, potentially using debug sastrace.<BR /> <BR /> /Linus Wed, 10 Jun 2009 16:35:08 GMT LinusH 2009-06-10T16:35:08Z https://communities.sas.com/t5/SAS-Procedures/how-to-convert-oracle-clinical-views-to-sas-data-sets/m-p/42893#M11187 Hi,<BR /> I was extracted a view from the oracle clinical and i am trying to convert to a sas dataset but its giving a following error. any one can you please resolve the problem.<BR /> <BR /> ERROR: ORACLE connection error: ORA-12560: TNS:protocol adapter error.<BR /> ERROR: SQL View could not be processed because at least one of the data sets, or views,referenced directly (or indirectly) by it could not be located, or opened successfully. Wed, 10 Jun 2009 10:23:03 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-convert-oracle-clinical-views-to-sas-data-sets/m-p/42893#M11187 deleted_user 2009-06-10T10:23:03Z https://communities.sas.com/t5/SAS-Procedures/how-to-convert-oracle-clinical-views-to-sas-data-sets/m-p/42894#M11188 First try to find out where the problem is.<BR /> Try to logon to Oracle through a non-SAS connection, using the same user/schema, and try to query the same view. <BR /> If this works, open a track to SAS support and attach a full LOG, potentially using debug sastrace.<BR /> <BR /> /Linus Wed, 10 Jun 2009 16:35:08 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-convert-oracle-clinical-views-to-sas-data-sets/m-p/42894#M11188 LinusH 2009-06-10T16:35:08Z