Re: Visual Information Retrieval

Is all the ConText stuff set up OK ... I don't know much about this ?

Looks like it might depend on the PLSExtproc stuff ...

ORA-28575 unable to open RPC connection to external procedure agent

Cause: Initialization of a network connection to the external procedure agent did not succeed. This problem can be caused by network problems, incorrect listener configuration, or incorrect transfer code.

Action: Check listener configuration in LISTENER.ORA and TNSNAMES.ORA, or check Oracle Names Server.

"Marlena" <annadduci_at_libero.it> wrote in message news:14c77a77.0303120244.524f57eb_at_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 - 06:51:07 CST