If you are still having issues after consulting the documentation, then your best bet for help is to contact someone at your site who already uses SAS/Access to Oracle (who may have some sample code) or contact SAS Tech Support.
Thank you very much.
I do have the libname statement to point to the oracle table. My stored process with this libname statement runs fine. I do not know why the following code gives error
libname ODSP oracle path=odsp schema=odsmgr user=ods_view2 password= XXXXXXXXXXX ;
ERROR: The ORACLE engine cannot be found.
ERROR: Error in the LIBNAME statement.
16 proc sql;
17 select count(*) from odsp.fund_hierarchy;
ERROR: Libname ODSP is not assigned.
You did not say in your original post that this was a stored process. Are you sure that the LIBNAME statement is correct for a Stored Process that uses the metadata server? Are your Oracle tables defined in the metadata with the correct engine? Are you sure your Workspace server or Stored Process server can "talk" to the Oracle server?
How did you build your stored process? From an EG project that was working or from an EG project that had errors reading the Oracle file? I believe, that in the Enterprise Intelligence Platform, there also could be some configuration and platform administration issues about which servers "know" about the location of the database tables and therefore, affect, which servers you choose to execute your stored process.
To me, this seems to be a question best answered by SAS Tech Support.