External procedure, perhaps? Although this is the kind of requirement that makes me uncomfortable ... Stephane Faroult RoughSea Ltd <http://www.roughsea.com> Konagora <http://www.konagora.com> RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd> On 10/07/2010 03:28 PM, Scott Canaan wrote: > > I need to be able to call a unix program or script from PL/SQL, > particularly from a trigger. There must be a way to do this, but I > can't find anything in the Oracle documentation, other than running > from SQL*Plus. I can't use SQL*Plus, it has to be a stored procedure > / function in the database. Is there a package that would work for this? > > This needs to work for both Oracle 10g and 11g. > > > > Thank you, > > > > Scott Canaan '88 (Scott.Canaan@xxxxxxx <mailto:Scott.Canaan@xxxxxxx>) > > (585) 475-7886 -- work (585) 339-8659 - cell > > "Life is like a sewer, what you get out of it depends on what you put > into it." - Tom Lehrer. > > >