Oracle Question

Is it possible to invoke an external process eg. java app or shell script from a stored procedure?



Thanks

Quote:

---

Originally posted by Mark Sreeves
Is it possible to invoke an external process eg. java app or shell script from a stored procedure?



Thanks

---

Well who executes the app ?

Quote:

---

Originally posted by plenderj


Well who executes the app ?

---

A trigger

Quote:

---

Originally posted by Mark Sreeves


A trigger

---

No I mean when this process is being invoked, what system is it going to be running on ?
The server itself, or a workstation or ...?

Er... um...

The shell script will run on the same server as the Oracle database sits and I need it to be kicked off by a trigger.

Is this possible?

well, you can definatly call Java Classes from PLSQL (stored procedures), but as is typical of Oracel and its documentation, details are not easy to get hols of. try:

http://download-west.oracle.com/otnd...call.htm#11760

It seems you need to publish the class and its methods as a procedure...

Don't know about shell scripts - I'm sure there is some DBMS_ package that will do it

Let me know if you need any help on the PLSQL side though :)

Oh and Mark/???? ( ;) ), check what version of Oracle you are using - Anything less than 8i tends to require workarounds...

Thanks Gaffer ;)