Problems with resizing JPEG-images with interMedia on 9i

Hi there,
I've got a problem with interMedia on Oracle 9i. I want to make some JPEG-processing (resizing, etc.) but it doesn't work. I can write the image to the DB, but when I want to call ORDSYS.ORDImage.processCopy() or ORDSYS.ORDImage.process() I always get the following error:

--

ORA-29400: data cartridge error
IMG-00703: unable to read image data
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "ORDSYS.ORDIMGEXTCODEC_PKG", line 159
ORA-06512: at line 1
ORA-06512: at "ORDSYS.ORDIMG_PKG", line 525
ORA-06512: at "ORDSYS.ORDIMAGE", line 59
ORA-06512: at line 10

My code for creating the thumbnail is as follows:

--

DECLARE
  imgSrc ORDSYS.ORDImage;
  imgDst ORDSYS.ORDImage;
BEGIN
  UPDATE imagesource SET thumbnail = ORDSYS.ORDImage.init() WHERE id = 1281;
  SELECT image INTO imgSrc FROM imagesource WHERE id = 1281;   SELECT image INTO imgDst FROM imagesource WHERE id = 1281 FOR UPDATE;   imgSrc.processCopy('maxscale=160 120', imgDst);   UPDATE imagesource SET thumbnail = imgDst WHERE id = 1281; END;
--

In the documentation (which can also be viewed online at http://www.oracle.com/technology/products/intermedia/htdocs/intermedia_quickstart/intermedia_quickstart.html) it says:

--

In Oracle Database release 9i, JPEG (and some other less common formats) encoding and decoding requires the external procedure agent (extproc). To fix the preceding error, the Oracle Listener needs to be configured to use extproc. See technical note 198099.1, Configuration of the External Procedure Call for interMedia at http://metalink.oracle.com for detailed instructions on setting up extproc. Oracle Database release 10g does not require extproc for JPEG encoding and decoding.
--

So our admin performed all these steps described in that technical note (and restarted the server without getting any error messages), but it still doesn't work. The steps performed were:

1. Added "(SID_NAME=extproc)" inside of "(SID_DESC=" brackets in "listener.ora"
2. Added the following to the end of "tnsnames.ora":

--

extproc_connection_data =

   (DESCRIPTION=(ADDRESS=(PROTOCOL=tpc)(KEY=PLSExtProc))    (CONNECT_DATA=(SID=extproc)))
--

It works fine with GIFs, but not with JPEGs. Could someone help me out? Thanks in advance. Received on Thu Dec 22 2005 - 04:39:09 CST