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 10:36:39 -0400
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@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:
