How to run a Unix script from another server ??

rajeevs · Post by **rajeevs** » Thu Jan 12, 2006 10:59 am

From DataStage (which is on one server), how do you run a unix script from Oracle (which is on another server)?

ArndW · Post by **ArndW** » Thu Jan 12, 2006 1:10 pm

Use a call to UNIX shell script and use rsh.

rajeevs · Post by **rajeevs** » Thu Jan 12, 2006 1:52 pm

ArndW wrote:Use a call to UNIX shell script and use rsh.

If you do not mind Can you please explain in detail ??

kcbland · Post by **kcbland** » Thu Jan 12, 2006 2:11 pm

From the Unix prompt, type in "man rsh" and read it in detail. You can always use Google.

rleishman · Post by **rleishman** » Thu Jan 12, 2006 4:15 pm

...how do you run a unix script from Oracle

Taking you literally, to run a Unix script from Oracle, see http://www.orafaq.com/forum/mv/msg/5517 ... msg_147495

In short, it's easy on Oracle 10g using DBMS_SCHEDULER package, trickier otherwise because you have to write you own launcher in C and hook it into PL/SQL. Once you get a PL/SQL stored procedure calling your script, just call the stored proc from the after-sql of the OCI stage with

Code: Select all

call proc_name(args)