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

On 3 Feb 2004 14:34:05 -0800, gpedro (AT) tiscali (DOT) it (Pie) wrote:


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