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 10:36:39 -0400
Message-ID: <001001c43dae$be8ea600$2501a8c0@dazasoftware.com>

Thanks

My problem is the following
I want to get the line where the text serach is For example serachibng Oracle you get

Doc1 ...... Oracle Corporation is a business..... Doc2 ...Oracle database is currently 10g..... etc.

There is a command, but in a blob storing a pdf document I get unreadable text

SQL> declare
  2 resarr ctx_query.browse_tab;
  3 begin
  4
ctx_query.browse_words('SEARCH_IDX','Database',resarr,10,CTX_QUERY.BROWSE_A ROUND);
  5 for i in 1..resarr.count loop
  6 dbms_output.put_line(resarr(i).word || ':' || resarr(i).doc_count);   7 end loop;
  8 end;
  9 /

SQL> set serveroutput on
SQL> /
9,999.99i:1
999,999,999:1
999,999,999,999:1
99999999999:1
9999999999S:1
DATABASEADMINISTRATOR:1
DATABASEADMINISTRATORiS:1
ã:1
ã--:1
ð:2

If you know how to do it using Oracletext or Oracle Ultasearch please

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 - 09:37:25 CDT