You can also run DLLs outside of the defaults Dick mentioned by setting the
EXTPROC_DLLS environment variable in your listener.ora. See MetaLink note
198523.1 for more information.
Jason Heinrich
Oracle Database Administrator
Pensacola Christian College
> From: "Goulet, Dick" <DGoulet_at_vicr.com>
> Date: Mon, 12 Sep 2005 13:42:50 -0400
> Subject: RE: Help with extproc procedure
>
> In Oracle 9i they made a change to the Extproc agent. It will only
> recognize and load shared libraries in the $ORACLE_HOME/lib or
> $ORACLE_HOME/bin directories. If $SDS_HOME is not the same as
> $ORACLE_HOME it will not work.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> Sent: Monday, September 12, 2005 12:18 PM
> Subject: Help with extproc procedure
>
> Guys...
>
> would you mind to review this conf?
> I'm having problems to execute an ext proc.
>
> ERROR:
> -------------
> SQL> exec sds_admin.LMConnect_Password('sds_sys');
> BEGIN sds_admin.LMConnect_Password('sds_sys'); END;
>
> *
> ERROR at line 1:
> ORA-20101: SDS_Sys password changed but procedure
> FAILED to store new value in
> SDS_Parameter table. -28595:::ORA-28595: Extproc agent
> : Invalid DLL Path
> ORA-06512: at "SDS_SYS.SDS_ADMIN", line 1466
> ORA-06512: at line 1
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 12 2005 - 13:28:22 CDT
