Re: Does anyone have experience using inso filters for all kind of documents for Oracle text
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 May 2004 11:58:32 -0400
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
