Re: PL/SQL and OS(UNIX) calls

From: Mark Gumbs <mgumbs_at_nospam.hotmail.com>
Date: Fri, 28 May 1999 08:57:37 +0100
Message-ID: <374e4a2f.0@145.227.194.253>

One way to do it is the host command but that can only be used in oracle forms or from SQL*Plus.

You may want to create an external procedure, written in C which calls sql*loader. The external proc is callable from pl/sql.

If anyone knows of another way, i wouldn't mind having the solution too!

Mark

smfrank_at_my-deja.com wrote in message <7il35d$psd$1_at_nnrp1.deja.com>...
>Is it possible to send commands to the operating system from a PL/SQL
>package? I want to be able to call SQL*Loader from a package using the
>command line arguments.
>
>Any input would be greatly appreciated,
>Shawn Franklin
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri May 28 1999 - 02:57:37 CDT