Connecting to oracle with libname - tables don't show up.

thesasuser — Wed, 11 Mar 2020 16:55:34 GMT

Hello
We recently moved to SAS 9.4M6 from SAS9.4 M4.
Using SAS EG 7.13.
SAS Servers are on windows server 2016.
ORACLE wallet is used to connect to ORACLE databases.
Some new database connections were made, resulting in new entries in the oracle wallet.
There is an issue with new entries /databases.
With the following libname statement the library is created and the tables in the library/database can be seen in the explorer window by clicking the library..
libname mylib oracle path=mypath;
However if the statement is modified as below to include the schema, i see from the log output that the library is created. I can see the library name in dictionary.members, but it has no members. Obviously I cannot see the members/tables in the explorer window in the SAS Enterprise guide.
libname mylib oracle path=mypath schema=MYSCHEMA;

The schema MYSCHEMA is a public schema.

the log output is

NOTE: Libref MYLIB was successfully assigned as follows:
Engine: ORACLE
Physical Name: MYPATH

.
Have tried changing the case of mypath and schema, enclosing in single and double quotes. But this did not help.

I have read the following, and host of other posts in sas communities but did not find an application.

https://documentation.sas.com/?docsetId=acreldb&docsetTarget=p1qft7bzdij79zn1bxh59mc3w8xj.htm&docsetVersion=9.4&locale=en
https://communities.sas.com/t5/SAS-Communities-Library/A-quick-guide-to-connecting-to-Oracle-from-SAS/ta-p/331849
https://communities.sas.com/t5/SAS-Programming/Not-able-to-view-the-table-in-library-but-able-to-read-data/td-p/586951
https://communities.sas.com/t5/SAS-Programming/Connecting-to-Oracle-via-libname-odbc-Schema-spec-doesn-t-work/m-p/17859/highlight/true#M2623

Can anybody help?

Re: Connecting to oracle with libname - tables don't show up.

thesasuser — Wed, 11 Mar 2020 17:19:14 GMT

Thanks.
The issue was with oracle level and was fixed.

topic Re: Connecting to oracle with libname - tables don't show up. in SAS Programming

Connecting to oracle with libname - tables don't show up.

Re: Connecting to oracle with libname - tables don't show up.