Any idea to run those kind of scripts from Oracle PL/SQL? Any solution would be appreciated. Thanks!
有没有想过从Oracle PL / SQL运行这些脚本？任何解决方案将不胜感激。谢谢！
2 个解决方案
#1
1
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.
我猜它通常是相反的，从SAS或R调用数据库。在SAS数据管理产品中有一个Oracle接口，看到SAS销售人员吹嘘如何将数据库中的表视为任何其他表SAS中的表（但这是基础SAS的附加软件包）。在R你有几个选择;一般的ODBC连接，特定的Oracle数据库接口和方便的工具，以及Oracle自己一直在为Oracle数据挖掘提供R接口。虽然我已经看过PostgresSQL的这样一个项目，但不知道Oracle直接调用R。
#2
0
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
尝试DBMS_SCHEDULER包 - 安排OS / SAS脚本作为作业运行。 http://www.oradev.com/dbms_scheduler.jsp和http://forums.oracle.com/forums/thread.jspa?threadID=414652
#1
1
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.
我猜它通常是相反的，从SAS或R调用数据库。在SAS数据管理产品中有一个Oracle接口，看到SAS销售人员吹嘘如何将数据库中的表视为任何其他表SAS中的表（但这是基础SAS的附加软件包）。在R你有几个选择;一般的ODBC连接，特定的Oracle数据库接口和方便的工具，以及Oracle自己一直在为Oracle数据挖掘提供R接口。虽然我已经看过PostgresSQL的这样一个项目，但不知道Oracle直接调用R。
#2
0
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
尝试DBMS_SCHEDULER包 - 安排OS / SAS脚本作为作业运行。 http://www.oradev.com/dbms_scheduler.jsp和http://forums.oracle.com/forums/thread.jspa?threadID=414652