From oracle-l-bounce@freelists.org Fri Mar 12 08:01:44 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2CE1ib06499 for ; Fri, 12 Mar 2004 08:01:44 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2CE1ho06491 for ; Fri, 12 Mar 2004 08:01:43 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8AB1239503F; Fri, 12 Mar 2004 09:00:59 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 12 Mar 2004 08:59:44 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from gcrta.org (clevelandrta.org [209.49.247.27]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id B2EB9394F08 for ; Fri, 12 Mar 2004 08:59:40 -0500 (EST) Received: from MAIN-Message_Server by gcrta.org with Novell_GroupWise; Fri, 12 Mar 2004 09:04:55 -0500 Message-Id: X-Mailer: Novell GroupWise Internet Agent 5.5.3.1 Date: Fri, 12 Mar 2004 09:04:31 -0500 From: "Jeffrey Beckstrom" To: , , , , Subject: external proc fails on 9.2 windows Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_2D0C3197.48296EAB" X-archive-position: 651 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: JBECKSTROM@gcrta.org Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l --=_2D0C3197.48296EAB Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable This is what we do in 8i and it works: CREATE OR REPLACE LIBRARY rta.nt_lib IS 'c:\windows\system32\kernel32.dll';= / create or replace function rta.run(lpCmdLine IN varchar2, nCmdShow IN binary_integer) return binary_integer AS EXTERNAL NAME "WinExec" LIBRARY rta.nt_lib CALLING STANDARD PASCAL; / This is script we run.... declare=20 ret_bin binary_integer; cmd varchar2(600); begin /* main routine */ cmd :=3D'f:\temp\extproc_test.bat'; ret_bin :=3D rta.run(cmd,0); end; /=20 Here is what the "bat" file being invoked contains: dir >f:\temp\extproc_test.log =20 If do the same on a new server with 9.2 installed I get: ERROR at line 1: ORA-28576: lost RPC connection to external procedure agent ORA-06512: at "RTA.RUN", line 0 ORA-06512: at line 10 The extproc_test.log file is being created so it is running the bat file, = just=20 get an error though. Any ideas???? =20 Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 --=_2D0C3197.48296EAB Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML

This is what we do in 8i and it works:
CREATE OR REPLACE LIBRARY=20= rta.nt_lib IS 'c:\windows\system32\kernel32.dll';
/
create or=20 replace
function rta.run(lpCmdLine IN varchar2, nCmdShow IN binary_integ= er)=20 return
binary_integer
AS EXTERNAL
NAME "WinExec"
LIBRARY=20 rta.nt_lib
CALLING STANDARD PASCAL;
/
This is script we=20 run....
declare
ret_bin binary_integer;
cmd=20 varchar2(600);
begin
/* main routine */
cmd=20 :=3D'f:\temp\extproc_test.bat';
ret_bin :=3D rta.run(cmd,0);
end;
= /=20
Here is what the "bat" file being invoked contains:
dir=20 >f:\temp\extproc_test.log

If do the same on a new server with 9.2 installed I get:

ERROR at line 1:
ORA-28576: lost RPC connection to external = procedure=20 agent
ORA-06512: at "RTA.RUN", line 0
ORA-06512: at line 10

Th= e=20 extproc_test.log file is being created so it is running the bat file, = just=20
get an error though.

Any ideas????

Jeffrey Beckstrom
Database Administrator
Greater Cleveland = Regional=20 Transit Authority
1240 W. 6th Street
Cleveland, Ohio=20 44113

--=_2D0C3197.48296EAB-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------