Hi...well, it depends on whether you have a "standalone" EG install and are using SAS on a server or whether you are working within the confines of the Enterprise Intelligence Platform (where all data access is controlled through the Metadata Server).
Generally speaking, the LIBNAME statement has a way to point to an Oracle table and thus, allow you to treat the table as a SAS data set.
[pre]
libname myoralib oracle user="robert" password="mypswd" path="thepath" ;
[/pre]
Subsequent references to your table would then be
[pre]
data=myoralib.mytable
[/pre]
However, the answer really is more involved than just issuing a LIBNAME statement -- your SAS administrator may need to ensure that you have the appropriate SAS/Access product for Oracle and make sure that you have the correct access privileges to the tables.
I suggest that you contact Tech Support for the correct answer considering your particular configuration and installation setup.
cynthia