RE: ORA-28595 when calling external proc

Thanks a lot!

Adding "EXTPROC_DLLS=." in listener.ora made it working.  

Igor Neyman, OCP DBA

ineyman_at_perceptron.com    

-----Original Message-----
Alexander.Feinstein_at_mitchell1.com
Sent: Monday, November 24, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L  

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-----
Sent: Monday, November 24, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L

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

ineyman_at_perceptron.com    

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).