Hi,

I'm tryign out the example from here:
http://www.oracle.com/technology/ora...p/o54text.html

I tried the following query, but nothing is being logged inside text_index.txt.

exec ctx_output.start_query_log(
'text_index.txt');

SET SERVEROUTPUT ON

DECLARE
v_title VARCHAR2(50);
BEGIN
FOR y IN 1..10
LOOP
BEGIN

SELECT title
into v_title
FROM songs
WHERE ID = 3
AND CONTAINS (title,
'mice') > 0;

EXCEPTION
WHEN NO_DATA_FOUND
THEN
NULL;
END;
END LOOP;
END;
/
exec ctx_output.end_query_log;

PLease help. Thanks.