BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,
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.

ERROR: ORACLE connection error: ORA-12560: TNS:protocol adapter error.
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.
1 REPLY 1
LinusH
Tourmaline | Level 20
First try to find out where the problem is.
Try to logon to Oracle through a non-SAS connection, using the same user/schema, and try to query the same view.
If this works, open a track to SAS support and attach a full LOG, potentially using debug sastrace.

/Linus
Data never sleeps

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand in the Innovate Hub.

Watch Now →
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1324 views
  • 0 likes
  • 2 in conversation