calling Unix shell script from a forms or pl/sql program

[kris123]

Hi!


I want to call a unix shell script from a pl/sql code.How to do that?.I have oracle 8i system installed on my Unix machine.


Thanks

[jgmagnus]

Normally I do that the other way around ...
shell script calling a pl/sql script ...

Any reason why you gotta do it your way?

- Magnus

[kris123]

The Unix shell script is to be issued from a frontend application that runs external process and focus back to front end and do some thing else with the front end.I am familiar calling pl/sql from shell script for a back end job
Any idea of calling from front end is appreciated

thanks in advance

[akkerend]

Use external procedure.