RE: DLL PATH NOT FOUND

Or, place the dll in $ORACLE_HOME/bin or $ORACLE_HOME/lib. I'm not a fan of the extproc_dlls variable. Leaves too many openings for others to create dll's or SO's that people can then link in.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Reidy, Ron Sent: Friday, December 09, 2005 3:59 PM
To: alavihamid_at_gmail.com; Oracle-L
Subject: RE: DLL PATH NOT FOUND

>From the error docs:
 

$ 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.  

Metalink note on extproc you might find usefull 312564.1  

 -----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of hamid alavi Sent: Friday, December 09, 2005 12:22 PM To: Oracle-L
Subject: DLL PATH NOT FOUND

list,

when i try to execute an pl/sql package i get the following error:

i have search on internet & they mentioned i have to change my listener, but i need an real example: please

SQL> exec PROCTRUENAME_WRAPPER ('CHUCKWUDOLE,PATRICK',:p2,:p3,:p4,:p5);

BEGIN PROCTRUENAME_WRAPPER ('CHUCKWUDOLE,PATRICK',:p2,:p3,:p4,:p5); END;  

*

ERROR at line 1:

ORA-28595: Extproc agent : Invalid DLL Path

ORA-06512: at "RESULTS.PROCTRUENAME", line 0

ORA-06512: at "RESULTS.PROCTRUENAME_WRAPPER", line 34

ORA-06512: at line 1

-- 
Hamid Alavi
(C) 818-416-5095
(F) 206-338-2375 

  _____  

This electronic message transmission is a PRIVATE communication which
contains information 
which may be confidential or privileged. The information is intended to
be for the use of the individual 
or entity named above. If you are not the intended recipient, please be
aware that any disclosure, 
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender 
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), 
and then delete it from your system. 


--
http://www.freelists.org/webpage/oracle-l