Re: Intermedia problem

On 3 Feb 2004 14:34:05 -0800, gpedro_at_tiscali.it (Pie) wrote:

>Hi,
>I have a problem with the signature function in oracle intermedia.
>I had created a small DB with an ORDImage object and
>ORDImageSignature, I put some images inside and i tried to create a
>signature of those...in this way:
>
>create directory IMMAGINI as 'c:\\giampiero';
>GRANT READ ON DIRECTORY IMMAGINI TO PUBLIC WITH GRANT OPTION
>
>DECLARE
>Image ORDSYS.ORDImage;
>ImageSig ORDSYS.ORDImageSignature;
>ctx RAW(4000) := NULL;
>BEGIN
>
>SELECT Foto, Foto_Sig INTO Image, ImageSig FROM Foto
>WHERE ID_Foto = 3 for UPDATE;
>Image.setSource('file','IMMAGINI','Img3-1.jpg');
>Image.import(ctx);
>ImageSig.generateSignature(Image);
>
>UPDATE Foto SET Foto = Image, Foto_Sig = ImageSig WHERE ID_Foto = 3;
>COMMIT;
>END;
>
>But the server return to me this error and...somebody can help me?
>
>DECLARE
>*
>ERRORE alla riga 1:
>ORA-29400: errore della cartuccia dati
>IMG-00703: impossibile leggere i dati dell'immagine
>ORA-28575: impossibile aprire una connessione RPC ad un agente di
>procedura esterna
>ORA-06512: a "ORDSYS.ORDIMGEXTCODEC_PKG", line 159
>ORA-06512: a line 1
>ORA-06512: a "ORDSYS.ORDIMG_PKG", line 525
>ORA-06512: a "ORDSYS.ORDIMAGE", line 59
>ORA-06512: a "ORDSYS.ORDIMAGESIGNATURE", line 85
>ORA-06512: a line 11

You need to configure the listener for external procedures. You don't seem to have the appriopiate protocol entry (protocol=ipc)(key=extproc)
and the appropiate sid entry (which I don't remember and is also documented)

--
Sybrand Bakker, Senior Oracle DBA