Oracle Question

[Mark Sreeves]

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



Thanks

[plenderj]

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 ?

[Mark Sreeves]

Originally posted by plenderj


Well who executes the app ?

A trigger

[plenderj]

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 ...?

[Mark Sreeves]

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?

[Gaffer]

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

[Gaffer]

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

[Mark Sreeves]

Thanks Gaffer