Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help me with Visual Information Retrieval

Help me with Visual Information Retrieval

From: Marlena <annadduci_at_libero.it>
Date: 12 Mar 2003 01:15:29 -0800
Message-ID: <14c77a77.0303120115.160e66c@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 - 03:15:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US