Removing HTML Tags from a varchar2 field

From: the matt <matt_at_kettlewell.net>
Date: Thu, 09 Aug 2007 15:13:40 -0700
Message-ID: <1186697620.745869.304040@z24g2000prh.googlegroups.com>

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 Received on Thu Aug 09 2007 - 17:13:40 CDT