USER_DATASTORE procedure and ctx_doc.markup
Hello
Oracle 11.2
I create USER_DATASTORE like:
Oracle 11.2
I create USER_DATASTORE like:
CREATE OR REPLACE PROCEDURE prc_fs_file_idx (p_rowid IN ROWID, p_clob IN OUT NOCOPY CLOB)
AS
v_clob CLOB;
BEGIN
FOR r IN (SELECT mt.id, tt.data
FROM fs_file mt, fs_file_space_1 tt
WHERE mt.id = tt.id AND mt.ROWID = p_rowid)
LOOP
DBMS_LOB.CREATETEMPORARY (v_clob, TRUE);
CTX_DOC.IFILTER (r.data, v_clob);
DBMS_LOB.WRITEAPPEND (p_clob, 6, '<body>');
DBMS_OUTPUT.PUT_LINE(sysdate);
DBMS_LOB.APPEND (p_clob, v_clob);
DBMS_LOB.WRITEAPPEND (p_clob, 7, '</body>');
DBMS_LOB.FREETEMPORARY (v_clob);
0