HELP: Visual Information Retrieval newbie ...

From: <tobyed2_at_my-deja.com>
Date: Fri, 04 Feb 2000 11:15:38 GMT
Message-ID: <87ecco$v44$1@nnrp1.deja.com>

I am unable to get information from a loaded ORDSYS.ORDVir image.

The method I have used (following the Oracle Visual Information and Retrieval User Guide), I have create a table as follows

CREATE TABLE PHOTOS
( PHOTO_ID INTEGER,
   PHOTO ORDSYS.ORDVir);

I then tried the example given for loading images via PLSQL BUT it failed ! (great example ...) The following is exactly as published -

DECLARE

   image     ORDSYS.ORDVIR;
   IdNum     NUMBER;

BEGIN

• Generate a photo ID and insert a row into the table.
• Note: empty_blob() is the initializer for the BLOB attribute. IdNum := 1; INSERT INTO stockphotos VALUES (IdNum, 'Janice Gray', 'Living room, full-length drapes, modern furniture', ORDSYS.ORDVIR(ORDSYS.ORDImage( ORDSYS.ordsource( empty_blob(),'FILE','ORDVIRDIR','virdemo1.dat',sysdate, 0), NULL, NULL, NULL, NULL, NULL,NULL,NULL), NULL)); SELECT photo INTO image FROM stockphotos WHERE photo_id = IdNum FOR UPDATE;
• Set property attributes for the image data. image.SetProperties;
• Read the data into the database. image.import(NULL);
• Generate the image signature. image.Analyze;
• Update the photo column with the contents of image.
• This also stores the signature and other image-specific attributes. UPDATE stockphotos SET photo = image WHERE photo_id = IdNum; END; /

This fails on image.import(null), argument cannot be NULL.

OK, so I then used the SQL*Loader method

LOAD DATA
INFILE *
INTO TABLE photos
APPEND
FIELDS TERMINATED BY ','
(
  photo_id,
  photo column object

     (image column object
        (source column object
           (localData_fname FILLER CHAR(4000),
            localData LOBFILE(photo.image.source.localData_fname) RAW
                 TERMINATED BY EOF
            )
         )
       )

 )
BEGINDATA
1, vauxhall_astra.jpg,
2, vauxhall_cavalier.jpg,

"Allegedly" this has added the records and a count(*) on table confirms 2 records YET

Interogating the width using getWidth returns NULL, Calling checkProperties fails to complete (process needs then killing), isLocal returns TRUE,

My immediate thought is that the SQLLoader is not enough, possibly need to Analyze the image and generate a signature ????

I HAVE successfully been able to use DBMS_LOB to open and read data, its just Id like to move on and be able to compare images ...

Thank you for any help

Toby

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 04 2000 - 05:15:38 CST