SQL & PL/SQL

Dear Sir,

Database: Oracle9i 9.2.0.7 Enterprise Edition
Platform: Solaris 8

When my plsql program try to create the thumbnail, I got the following error message.

ORA-29400: data cartridge error IMG-00703: unable to read image data ORA-28595: Extproc agent : Invalid DLL Path ORA-06512: at "ORDSYS.ORDIMGEXTCODEC_PKG", line 159 ORA-06512: at line 1

I followed Note:198099.1 to setup the listener.ora and tnsnames.ora but I'm still got the same error.

Below are my tnsnames.ora and listener.ora, please advice if they are correct.

Fyi, I verify my application logic for creation of thumbnail by using .gif image. The thumbnail can be created. So, meaning my application logic is correct and the problem is with .jpg which will only work if I got the configuration correct.

So, really appreciate some advice.
Thank you.

Regards,
Jap.


----------------------------------------------------------------------
# LISTENER.ORA Network Configuration File: /oracle/ora90/ora920/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1526))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/ora90/ora920)
(PROGRAM = extproc)
)
(SID_DESC=
(SID_NAME=extproc)
(ORACLE_HOME=/oracle/ora90/ora920)
(PROGRAM=extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = /oracle/ora90/ora920)
(SID_NAME = test)
)
)




----------------------------------------------------------------------

# TNSNAMES.ORA Network Configuration File: /oracle/ora90/ora920/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1526))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1526))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)