Re: Can Oracle call a batch file from a procedure???

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Sun, 09 Sep 2001 00:34:27 GMT
Message-ID: <nOym7.448545$p33.8527877_at_news1.sttls1.wa.home.com>


Yes. There are several ways to do this.

1. Write a C routine and have it poll a pipe.
2. Write an external C routine and have it make a system call.
3. Write a Java routine that resides within the database.  Search Metalink
for this. They have a nice example with code. #3 is probably the quickest and fastest to do. Jim
"Mendoza Family" <NetScans_at_ix.netcom.com> wrote in message news:3B9AAB45.AB2A8870_at_ix.netcom.com...
> I am running Oracle 8.1.6 and I need call a batch job. I would like to
> do it from within the procedure, is it possible? If so does any one have
> sample code I can use?
>
> I posted this message on three different Oracle groups, please send your
> response to both the group and my email address.
>
> Thanks,
> Moises
Received on Sun Sep 09 2001 - 02:34:27 CEST

Original text of this message