Re: host command for pl/sql

In article <65kc8a$3sm$1_at_gaul.lattis.xara.net>, dba <dba_at_europe.poppe.com> writes
>is there any way of calling Unix commands from pl/sql DB procedures in the
>same way that forms4.5 uses the HOST command
>
>
There isn't a 'HOST' equivalent.

In general you would write to a dbms_pipe with the other end being connected to a Pro* program which does whatever is asked of it.

Oracle have an unsupported PLEX utility on their government site which appears to do the above for Unix. It might be worth a look.

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG