Hi, Lana:
This is not really an ODS/Reporting question, so much as it is a data access question.
The answer is "it depends" -- on how SAS is licensed on your various servers and whether/where you have SAS/Access for Oracle licensed.
Generally speaking, if you have all the right pieces in the right places, then you could use the LIBNAME statement:[pre]
libname oralib oracle user=johndoe password=xxxxx path=YYYYYYYY;
[/pre]
OR, you could get to the ORACLE data using SAS/Access to ODBC or SAS/Access to OLE DB.
For more information, consult this documentation:
support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_oracle_7367.pdf
In order to find out the definitive way, given your site license and configuration, your best bet is to contact Tech Support:
http://support.sas.com/techsup/contact/index.html
Good luck!
cynthia