interMedia doesn't find my text

I am using Oracle 8.1.6 with interMedia 8.1.6 which I want to use to find text in my tables.
Is there a way to 'see' what text is being indexed?

my test table CONTEST_TEXT has the columns:

 CONTEST_HEADLINE      NULL VARCHAR2(250)
 GRAB_PARAGRAPH                      VARCHAR2(500)
 BODY_TEXT                                   LONG

and I index it using a 'user_datastore' following the example in the oracle documentation,
that is using a procedure that gathers the text together from several columns
I am in the dark as to what text is being indexed as sometimes 'contains' finds the lines and sometimes it doesn't. Perhaps is my procedure buggy and I am indexing the wrong text?

Please shed me some light.

Ronaldo

My steps to create the index:

exec ctx_ddl.drop_preference('contest_pref');
exec ctx_ddl.create_preference('contest_pref','USER_DATASTORE');
exec ctx_ddl.set_attribute('contest_pref', 'procedure', 's_p_contest');
exec ctx_ddl.set_attribute('contest_pref', 'output_type', 'clob');

create index i_contest_text
on contest_text(body_text)
indextype is ctxsys.context
parameters ('datastore contest_pref');

create procedure p_contest(rid in rowid, tlob in out NOCOPY clob) is   separator_space char(1) := ' ';
begin
  for c1 in (

         select contest_headline, grab_paragraph, body_text from contest_text

         where rowid = rid
  )
  loop
    dbms_lob.writeappend(tlob, length(c1.contest_headline), c1.contest_headline);

    dbms_lob.writeappend(tlob, 1, separator_space);     dbms_lob.writeappend(tlob, length(c1.grab_paragraph), c1.grab_paragraph);

    dbms_lob.writeappend(tlob, 1, separator_space);     dbms_lob.writeappend(tlob, length(c1.body_text), c1.body_text);

  end loop;
end; Received on Tue Jan 22 2002 - 03:14:02 CST