Can I convert .rtf BLOB to be HTML clob?
RjTanApr 29 2009 — edited May 4 2009Hi All,
I have this scenario which I need to convert word document (.rtf) and it is stored in a database as blob.
I need to convert it in html format (which handle the windows smart quotes) and do my string search in that column.
I'm using the scripts below but somehow its now converting it. Any other idea.
-------------------------
exec ctx_ddl.create_policy(policy_name => 'my_policy');
declare
l_clob clob;
begin
for x in
(select DOC_rtf_BLOB from TEST_BLOB_TABLE)
loop
ctx_doc.policy_filter(policy_name => 'my_policy',
document => x.DOC_rtf_BLOB,
restab => l_clob,
plaintext => FALSE,
charset => 'US7ASCII');
INSERT INTO TEST_CLOB_TABLE values ( l_clob ) ;
end loop;
end;