RE: ORA-28595 when calling external proc

[Igor Neyman]

Title: Message

Thanks a lot! Adding “EXTPROC_DLLS=…” in listener.ora made it working.   Igor Neyman, OCP DBA [EMAIL PROTECTED]     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, November 24, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-28595 when calling external proc   This is new features of 9.2. The same on LINUX.   oerr ORA 28595 28595, 00000, "Extproc agent : Invalid DLL Path" // *Cause:  The path of DLL supplied for the extproc execution is invalid. // *Action: Check if the DLL path is set properly using the EXTPROC_DLLS //          environment variable. //   add to listener.ora  (PROGRAM  =  extproc)  (ENVS="EXTPROC_DLLS=x:\path\a.dll;y:\path\b.dll") For more detail see 198523.1 External Procedure Calls and ORA-28595 using Oracle9i release 2 Alex.   -----Original Message----- From: Igor Neyman [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 9:19 AM To: Multiple recipients of list ORACLE-L Subject: ORA-28595 when calling external proc Oracle 9.2.0.1 on Windows XP I'm getting   ORA-28595: Extproc agent: Invalid DLL Path   when calling external procedure. I know, I specified the correct path to my dll, when issuing "CREATE LIBRARY...' statement. I noticed (when switched from 8.1.5 on NT to 9.2 on Win2000) that dll path became "case-sensitive" (all of a sudden). But, that's not a problem in this case. Any thoughts? Btw, ORA-28595 is not in "Error Messages" manual.   Igor Neyman, OCP DBA [EMAIL PROTECTED]