Any idea to run those kind of scripts from Oracle PL/SQL? Any solution would be appreciated. Thanks!
A:
Try the DBMS_SCHEDULER package - to schedule the OS/SAS script to run as a job. http://www.oradev.com/dbms_scheduler.jsp and http://forums.oracle.com/forums/thread.jspa?threadID=414652
Joe
2010-10-28 14:07:52
will check that.. thank you!
Toto
2010-10-28 15:26:28
+1
A:
I would guess it is more often the other way around, calling the database from SAS or R. There is a interface for Oracle in a SAS data management product, have seen SAS salesmen boasting about how tables in the database can be treated as any other table in SAS (but that was an additional software package to the base SAS). In R you have several options; general ODBC connection, specific Oracle database interface and convenient tools, and Oracle them selves have been providing interfaces in R for Oracle data mining. Don't know about Oracle calling R directly though I have seen such an project for PostgresSQL.
eyjo
2010-10-28 16:12:20
Yes, I know that. Oracle provides interfaces for SAS and R (ROracle package) but I need the opposit direction. I have the logic in Oracle, have several PL/SQL stored procs and some scripts in SAS and R. I need to run those scripts also.
Toto
2010-10-29 08:20:17