Calling a unix script from a pl/sql procedure

[jimmy80]

Hi i was wondering if it's possible to call a unix script from a pl/sql procedure.
Something like
If x = 0 then
call the unix script
else
don't
end if

Thanks for the help.
jimmy

 

[sem]

No, but you may create some simple library (.so) or java procedure calling your shell script. Read about calling EXTERNAL PROCEDURES in manual, some changes in listener.ora should be made.

Regards, Dima