Visual Information Retrieval

From: Marlena <annadduci_at_libero.it>
Date: 12 Mar 2003 02:44:29 -0800
Message-ID: <14c77a77.0303120244.524f57eb@posting.google.com>

I'm a italian girl and i dont know well english language...

I should want to work with Visual Information Retrieval on Oracle8i (8.1.7) but i had the following problem:

instruction:

INSERT INTO stockphotos
VALUES (IdNum,
'Janice Gray',
'Living room, full-length drapes, modern furniture',
ORDSYS.ORDVIR(ORDSYS.ORDImage( ORDSYS.ordsource( empty_blob(),'FILE','LOCAL','ellipse1.bmp',sysdate, 1), NULL, NULL, NULL, NULL, NULL,NULL,NULL), NULL)); error:

ERRORE alla riga 1:
ORA-28575: impossibile aprire una connessione RPC ad un agente di procedura
esterna

ORA-06512: a "ORDSYS.ORDIMG_PKG", line 419
ORA-06512: a "ORDSYS.ORDIMAGE", line 65
ORA-06512: a "ORDSYS.ORDVIR", line 27
ORA-06512: a line 15

Instruction:

INSERT INTO stockphotos VALUES
(1,
'Janice Gray',
'Living room, full-length drapes, modern furniture'
,ORDSYS.ORDVir.init('file','LOCAL','ellipse1.bmp'));

error: nothing . (row created)

instruction:

IMAGE.IMPORTFrom(ctx,'FILE','LOCAL','ellipse1.bmp');

error:
ERRORE alla riga 1:
ORA-06510: PL/SQL: mancata gestione dell'eccezione definita dall'utente
ORA-06512: a "ORDSYS.ORDSOURCE", line 266 ORA-22288: l'operazione su file o LOB FILEOPEN non è riuscita Impossibile trovare il file specificato.

ORA-06512: a "ORDSYS.ORDIMG_PKG", line 530
ORA-06512: a "ORDSYS.ORDIMAGE", line 219
ORA-06512: a "ORDSYS.ORDVIR", line 164
ORA-06512: a line 9

NOTA: i have created a directory whith read grant, further i have tested with package DBMS_LOB and work!

I LOOK FOR IN ALL GROUPS BUT I DONT FIND THE ANSWER FOR MY PROBLEM!!! HELP ME!!! Marlena Received on Wed Mar 12 2003 - 04:44:29 CST