Re: Does anyone have experience using inso filters for all kind of documents for Oracle text

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Wed, 19 May 2004 11:58:32 -0400
Message-ID: <004101c43dba$22bf4bb0$2501a8c0@dazasoftware.com>

Feighery, thanks your pr evious example is very useful,

please can I abuse from your help and ask you to give me a hand with this function

I want to use this function, because this will helpme to see all contents before opening the document, I am two hors and I can't get work please if you can give one example how using

CTX_DOC.IFILTER(barchivo, theclob);

The following example don't work CTX_DOC.IFILTER returns

ORA-06510: PL/SQL: excepción definida por el usuario no tratada
ORA-06512: en "CTXSYS.CTX_DOC", línea 1146
ORA-28575: no se ha podido abrir la conexión RPC con el agente de

procedimiento externo
ORA-06512: en línea 12

Without the CTX_DOC.IFILTER command it works

DECLARE CRETURN VARCHAR2(4000); barchivo BLOB;

theclob clob ;

BEGIN DBMS_LOB.CREATETEMPORARY(theclob,TRUE);

DBMS_LOB.OPEN(theclob,DBMS_LOB.LOB_READWRITE);

dbms_output.put_line('longitud 0');

CRETURN := pck_lob.leearchivo('a.pdf','MY_FILES',barchivo);

dbms_output.put_line(SubStr('"Return Value" = '||CRETURN,1,255));

dbms_output.put_line('longitud 1');

CTX_DOC.IFILTER(barchivo, theclob);

dbms_output.put_line('longitud 1 2');

insert into web.test values( 1,the_clob,barchivo );

dbms_output.put_line('longitud 2');

dbms_output.put_line('longitud 3');

DBMS_LOB.CLOSE(theclob);

DBMS_LOB.FREETEMPORARY(theclob);

COMMIT; END; /

Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed May 19 2004 - 10:59:07 CDT