08-05-2016 12:24 PM - edited 08-05-2016 12:24 PM
I have an Oracle table I would like to acces in SAS but using either the datastep or proc sql it returns the column headers but no rows of data. In SQL developer the same issue occurs, but I am able to resolve it by first running the SQL command below:
I have tried to run that exact SQL statement using the SQL pass-through facility as follows:
connect to oracle as ALIAS (user=username orapw=password path='path');
end; ) by ALIAS;
disconnect from ALIAS;
The issue is that whenever I run this I get an error that the table or view does not exist. I do not know if there the problem is with my proc sql or if there is other code that is the SAS equivalent of the SQL command above. I have tried it in both SAS 9.3 and Enterprise Guide 5.1.
Any help would be greatly appreciated. Thank you.
08-05-2016 05:25 PM
08-05-2016 05:34 PM
08-05-2016 11:23 PM
What you're trying to do should be possible.
As @SASKiwi already points out: Make sure that you run exactly the same code via Pass-through SQL than what you're using in SQL Developer (or the like).
Are you always using the same user and password?
Also make sure that once your first statement works that you issue your queries within the same session/connection.
Need further help from the community? Please ask a new question.