EXTPROC problem (DrWatson) on Oracle 8.0.3.0 running on NT4/SP3

From: Raj Gabrielse <craj_at_zdnetmail.com>
Date: Wed, 21 Apr 1999 16:51:26 +0200
Message-ID: <7fkpsp$fqs$1@zonnetje.NL.net>

Hi group,

I've created the demolib sample to run an external program using WinExec as per below, my TNSNAMES.ORA and LISTENER.ORA are also included below I'm trying this directly on the NT server, connected as adminsitrator, working local relative to Oracle

The problem:

When I try to call the demo.run function, I get a DrWatson on EXTPROC.EXE (access violation) and an 'ORA-28576 lost RPC connection to external procedure agent' EVERY TIME.

any help greatly appreciated
Raj Gabrielse

• demolib sample -------------------------- CREATE LIBRARY demolib as 'c:\winnt\system32\kernel32.dll' / show errors

CREATE OR REPLACE PACKAGE Demo IS
  function run(lpCmdLine IN varchar2,

               nCmdShow IN binary_integer) return binary_integer; end;
/
show errors

CREATE OR REPLACE PACKAGE BODY Demo IS

function run(lpCmdLine IN varchar2,

             nCmdShow IN binary_integer) return binary_integer   AS EXTERNAL
  NAME "WinExec"
  LIBRARY demolib
  parameters ( lpCmdLine STRING,

                nCmdShow    long );

end;
/
show errors

------------------- demolib sample --------------------------

------------------- tnsnames.ora --------------------------

Tcp-loopback.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = 127.0.0.1)


          (Port = 1521)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
extproc_connection_data.world =
  (DESCRIPTION =
    (ADDRESS =

        (PROTOCOL = IPC)
        (KEY = ORCL)

    )
    (CONNECT_DATA = (SID = extproc)
    )
  )

------------------- tnsnames.ora --------------------------

------------------- listener.ora --------------------------

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= oracle.world)


        )
        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= ORCL)


        )
        (ADDRESS=


          (PROTOCOL= TCP)


          (Host= craj_nt)


          (Port= 1521)


        )
        (ADDRESS=


          (PROTOCOL= TCP)


          (Host= craj_nt)


          (Port= 1526)


        )
        (ADDRESS=


          (PROTOCOL= TCP)


          (Host= 127.0.0.1)


          (Port= 1521)


        )

  )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0 SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = craj_nt)
      (ORACLE_HOME = d:\orant)
      (SID_NAME = ORCL)

    )
    (SID_DESC =

      (SID_NAME = extproc)
      (ORACLE_HOME = d:\orant)
      (PROGRAM = extproc)

    )
  )

PASSWORDS_LISTENER = (oracle)

------------------- listener.ora --------------------------

Received on Wed Apr 21 1999 - 09:51:26 CDT