Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can Oracle call a batch file from a procedure???

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@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 Sat Sep 08 2001 - 19:34:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US