Removing HTML Tags from a varchar2 field

Hello,

I'm trying to take some HTML fields (varchar2) and strip out the HTML
formatting. The Policy_Filter seems to want to use a Blob, but I
don't have one to give it, so I've tried various variations of the
code below.

DECLARE
output_c clob;
input_b blob;
BEGIN
SELECT
SARQUAN_QUESTION into input_b
FROM
SATURN.SPRIDEN,SATURN.SARQUAN
WHERE spriden_id LIKE '%70%' AND spriden_pidm=sarquan_pidm;
CTX_DOC.POLICY_FILTER('test_policy', input_b, output_c, TRUE);
END;
/


Any thoughts?

I'm new to Oracle, so go easy on me please :)

Thanks for your help

Matt

.

Relevant Pages