Does anyone have experience using inso filters for all kind of documents for 2004-05-19 - By Juan Cachito Reyes Pacheco
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 (See ORA-06510.ora-code.com): PL/SQL: excepción definida por el usuario no tratada
ORA-06512 (See ORA-06512.ora-code.com): en "CTXSYS.CTX_DOC ", línea 1146
ORA-28575 (See ORA-28575.ora-code.com): no se ha podido abrir la conexión RPC con el agente de
procedimiento externo
ORA-06512 (See ORA-06512.ora-code.com): 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
