SCOTT@orcl_11g> CREATE TABLE master
  2    (id	     NUMBER,
  3  	data	     CLOB)
  4  /

Table created.

SCOTT@orcl_11g> INSERT INTO master VALUES (1, 'parent test')
  2  /

1 row created.

SCOTT@orcl_11g> INSERT INTO master VALUES (2, 'another parent test')
  2  /

1 row created.

SCOTT@orcl_11g> CREATE TABLE detail
  2    (id	     NUMBER,
  3  	data	     CLOB)
  4  /

Table created.

SCOTT@orcl_11g> INSERT INTO detail VALUES (1, 'first child test')
  2  /

1 row created.

SCOTT@orcl_11g> INSERT INTO detail VALUES (1, 'second child test')
  2  /

1 row created.

SCOTT@orcl_11g> INSERT INTO detail VALUES (2, 'another child test')
  2  /

1 row created.

SCOTT@orcl_11g> CREATE OR REPLACE PROCEDURE test_proc
  2    (p_rowid IN ROWID,
  3  	p_clob	IN OUT NOCOPY CLOB)
  4  AS
  5  BEGIN
  6    FOR m IN (SELECT * FROM master WHERE ROWID = p_rowid) LOOP
  7  	 DBMS_LOB.WRITEAPPEND (p_clob, 13, '<master_data>');
  8  	 DBMS_LOB.APPEND (p_clob, m.data);
  9  	 DBMS_LOB.WRITEAPPEND (p_clob, 14, '</master_data>');
 10  	 FOR d IN (SELECT * FROM detail WHERE id = m.id) LOOP
 11  	   DBMS_LOB.WRITEAPPEND (p_clob, 14, CHR(10) || '<detail_data>');
 12  	   DBMS_LOB.APPEND (p_clob, d.data);
 13  	   DBMS_LOB.WRITEAPPEND (p_clob, 14, '</detail_data>');
 14  	 END LOOP;
 15    END LOOP;
 16  END test_proc;
 17  /

Procedure created.

SCOTT@orcl_11g> SHOW ERRORS
No errors.
SCOTT@orcl_11g> BEGIN
  2    CTX_DDL.CREATE_PREFERENCE ('test_datastore', 'USER_DATASTORE');
  3    CTX_DDL.SET_ATTRIBUTE ('test_datastore', 'PROCEDURE', 'test_proc');
  4  END;
  5  /

PL/SQL procedure successfully completed.

SCOTT@orcl_11g> CREATE INDEX text_index ON master (data)
  2  INDEXTYPE IS CTXSYS.CONTEXT
  3  PARAMETERS
  4    ('DATASTORE	test_datastore
  5  	 SECTION GROUP	CTXSYS.AUTO_SECTION_GROUP')
  6  /

Index created.

SCOTT@orcl_11g> CREATE OR REPLACE FUNCTION get_markup
  2    (p_rowid IN ROWID,
  3  	p_text	IN VARCHAR2)
  4    RETURN CLOB
  5  AS
  6    v_markup CLOB;
  7  BEGIN
  8    CTX_DOC.SET_KEY_TYPE ('ROWID');
  9    CTX_DOC.MARKUP
 10  	 (index_name	     => 'text_index',
 11  	  textkey	     =>  p_rowid,
 12  	  text_query	     => p_text,
 13  	  restab	     => v_markup,
 14  	  starttag	     => '[B]',
 15  	  endtag	     => '[/B]');
 16    RETURN v_markup;
 17  END get_markup;
 18  /

Function created.

SCOTT@orcl_11g> SHOW ERRORS
No errors.
SCOTT@orcl_11g> VARIABLE search_words VARCHAR2 (2000)