Re: PL/SQL calling external procedures

On Mon, 14 Jan 2002 19:48:13 -0000, Jeremy Ovenden <jovenden_NOSPAM_at_hazelweb.co.uk> a écrit:
>What I would like to be able to do is execute a program on the server but
>initiated by pl/sql procedure - does the external procedure have to be
>written in 'c' (as I believe is the case) or could one call e.g. a shell
>script (as I am hoping but not betting on it!)

What you can do with exproc is call a function in a shared library you declare to pl/sql.

You can imagine a function doing exec() calls in C. Beware of the costs in term of cpu/memory though.

-- 
Damien