Path: news.easynews.com!easynews!out.nntp.be!propagator-SanJose!news-in!newshub2.rdc1.sfba.home.com!news.home.com!news1.sttls1.wa.home.com.POSTED!not-for-mail Reply-To: "Jim Kennedy" From: "Jim Kennedy" Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server,comp.databases.oracle.misc References: <3B9AAB45.AB2A8870@ix.netcom.com> Subject: Re: Can Oracle call a batch file from a procedure??? Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: Date: Sun, 09 Sep 2001 00:34:27 GMT NNTP-Posting-Host: 65.4.45.60 X-Complaints-To: abuse@home.net X-Trace: news1.sttls1.wa.home.com 999995667 65.4.45.60 (Sat, 08 Sep 2001 17:34:27 PDT) NNTP-Posting-Date: Sat, 08 Sep 2001 17:34:27 PDT Organization: Excite@Home - The Leader in Broadband http://home.com/faster Xref: easynews comp.databases.oracle.tools:44613 comp.databases.oracle.server:117614 comp.databases.oracle.misc:68495 X-Received-Date: Sat, 08 Sep 2001 18:31:29 MST (news.easynews.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" wrote in message news:3B9AAB45.AB2A8870@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