RE: ORA-28595 when calling external proc

[Goulet, Dick]

Actually, since I use HP-UX, I was of the practice to keep a soft link to all of the SO files that we had in use in a specific directory off of $ORACLE_BASE.  It just saved a ton of other problems.  Now since Oracle in enforcing that my job becomes a touch easier.   Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Igor Neyman [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-28595 when calling external proc My bad. Thanks to everyone who replied.   Igor Neyman, OCP DBA [EMAIL PROTECTED]     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, Dick Sent: Monday, November 24, 2003 3:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-28595 when calling external proc   Well!!  You didn't say it that eXtreme Perversion  was the OS.   Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Igor Neyman [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-28595 when calling external proc $ORACLE_HOME/bin is where I put my dll.   What’s puzzling is that it works under 8.1.5/NT or 9.2/Win2000, but not under 9.2/XP.   Igor Neyman, OCP DBA [EMAIL PROTECTED]     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, Dick Sent: Monday, November 24, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-28595 when calling external proc   Igor,       I can't remember exactly where I read it, but under Oracle 9i the DLL or SO file(unix) needs to be in either $ORACLE_HOME/bin or $ORACLE_HOME/lib only.   Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Igor Neyman [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 12:19 PM 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]