Re: Call Host command in stored procs
From: Johan Wegener <xjwegener_at_xpost.xtele.xdk>
Date: Mon, 19 Jul 1999 16:39:18 +0200
Message-ID: <7mvd6k$ric$1_at_news.inet.tele.dk>
Date: Mon, 19 Jul 1999 16:39:18 +0200
Message-ID: <7mvd6k$ric$1_at_news.inet.tele.dk>
Kevin Cheung wrote in message <37909A46.B4FD138B_at_poboxes.com>...
>Is is possible to call a unix script/host command in a stored proc or
>package?
Not directly, but you can program your way around it:
- Using the DBMS_PIPE package, you can send arbitrary commands to a server process that in turn executes your shell script.
- Using database external procedures, you can call a function in a shared library that does a system() or exec*() that executes your script or command
Cheers,
Johan
Received on Mon Jul 19 1999 - 16:39:18 CEST