libname libA oracle user=xxxxx password=yyyy path=zzzz;
libname libB oracle user=xxxxx password=yyyy path=aaaa;
libname oralib oracle (libA libB);

proc sql;
connect using oralib;
ERROR: ORACLE connection error: ORA-12560: TNS:protocol adapter error.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
create table test as
select * from connection to oralib
(select * from table1);
NOTE: Statement not executed due to NOEXEC option.
quit;