Oracle 9.0.1 interMedia

From: Matt Albers <mfalbers_at_hotmail.com>
Date: 10 Sep 2002 17:20:50 -0700
Message-ID: <1f412b1f.0209101620.2f6be85a@posting.google.com>

I am trying to create a stored procedure to insert an image into the Oracle database using the interMedia packages. I am executing the following code in a Stored Procedure:

CREATE OR REPLACE procedure insert_image(

   pFilename IN VARCHAR) as

• application variables Image ORDSYS.ORDImage; emptyImage ORDSYS.ORDImage := ORDSYS.ORDImage.init(); emptyImageSig ORDSYS.ORDImageSignature := ORDSYS.ORDImageSignature.init(); ctx RAW(4000) := NULL; --current_seq_val NUMBER := NULL; nxtseq NUMBER := NULL; BEGIN DBMS_OUTPUT.PUT_LINE('------- BEGIN INSERT ---------'); DBMS_OUTPUT.PUT_LINE('filename : '|| pFilename);
  • first we need to create a new record in the media table
  • and return the media_id for later use DBMS_OUTPUT.PUT_LINE('inserting record to media'); INSERT INTO MEDIA (media_id) VALUES (media_id_seq.NEXTVAL) RETURNING media_id INTO nxtseq;
  • get the media_id for use later DBMS_OUTPUT.PUT_LINE('current media_id : '|| nxtseq);

   DBMS_OUTPUT.PUT_LINE('inserting record to content_image');    INSERT INTO CONTENT_IMAGE (media_id, content, content_sig)

      VALUES (nxtseq, emptyImage, emptyImageSig);

   DBMS_OUTPUT.PUT_LINE('selecting newly created record from content_image');

• Select the newly inserted row for update SELECT content INTO Image FROM CONTENT_IMAGE WHERE media_id = nxtseq for UPDATE;
• Can use the getContent method to get the LOB locator.
• Populate the data with DBMS LOB calls or write an OCI program to
• fill in the image BLOB.
• This example imports the image file test.gif from the ORDIMGDIR
• directory on a local file system
• (srcType=FILE) and automatically sets the properties.

   DBMS_OUTPUT.PUT_LINE('loading the file from ORDIMGDIR');	
   Image.setSource('file','ORDIMGDIR',pFilename);
   DBMS_OUTPUT.PUT_LINE('Image.import');	   

   Image.import(ctx);

   DBMS_OUTPUT.PUT_LINE('updating the image in content_image');    UPDATE CONTENT_IMAGE SET content = Image WHERE media_id = nxtseq;

EXCEPTION               WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN     DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');

   WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN     DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');

   WHEN ORDSYS.ORDSourceExceptions.INCOMPLETE_SOURCE_INFORMATION THEN     DBMS_OUTPUT.put_line('SOURCE INCOMPLETE_SOURCE_INFORMATION caught');         

   WHEN OTHERS THEN

      DBMS_OUTPUT.PUT_LINE('EXCEPTION caught ---> '||SQLERRM);
      DBMS_OUTPUT.PUT_LINE('------- END INSERT -----------');

END; Everything is ok until I get to Image.import(ctx); and then I am getting the following error:

ORA-29540: class oracle/ord/media/img/PropsAdapter does not exist

I cannot find any reference to this class anywhere in interMedia. Has anyone run across this before? And do you know if I am missing some magic jar that hold this class?

thanks in advance. Received on Tue Sep 10 2002 - 19:20:50 CDT