this is pretty easy - here is an example using a word document, one that I published here:
</code>
http://asktom.oracle.com/Misc/gripe-sheet.html <code>
ops$tkyte%ORA10GR2> exec ctx_ddl.create_policy( 'my_policy', 'ctxsys.inso_filter' );
PL/SQL procedure successfully completed.
ops$tkyte%ORA10GR2> create or replace directory MY_DIR as '/home/tkyte'
2 /
Directory created.
ops$tkyte%ORA10GR2> declare
2 l_bfile bfile;
3 l_clob clob;
4 begin
5 l_bfile := bfilename( 'MY_DIR', 'A_gripe_sheet.doc' );
6 dbms_lob.fileopen( l_bfile );
7 ctx_doc.policy_filter( 'my_policy', l_bfile, l_clob, true );
8 dbms_output.put_line( l_clob );
9 end;
10 /
A gripe sheet . Supposedly true ?gripes by pilots and the responses by
ground crew?. If they are true ? they show the ground crew has a really good
sense of humor. My top favorite on that page (it was really hard to choose):
Problem logged: Friction locks cause throttle levers to stick.
Solution
described: That's what they're there for.
I liked that most of all because
it is somewhat similar to some answers I?ve given in the past myself. ?It is
supposed to do that?.
It was either that one or the ?cannot reproduce on
ground? answer.
PL/SQL procedure successfully completed.