How to Parse CLOB varialbe in Coldfusion 9

Hi,

I am trying to parse CLOB variable in Coldfusion 9. Can you please help.

Below is the peice of code I wrote but getting exception(

Encountered "(. Incorrect Select Statement, Expecting a 'FROM', but encountered '(' instead, A select statement should have a 'FROM' construct.
).

ITEM_ATRS_LIST is a CLOB variable.

<cfquery   
            name = "AssignedProducts"  
            dbtype="query" >  
                select
                    ap_id, ap_version_id, service_type, state, main_item_id, ap_id_dominant, status, end_date, order_action_id
                    <cfoutput query="AttributeResultSet">
                            ,GET_ATR_VALUE(ITEM_ATRS_LIST, '#AttributeResultSet.ItemAtrsListVal#') #AttributeResultSet.QueryVal#
                    </cfoutput>
                    <!--- <cfoutput query="AttributeResultSet">
                        , #AttributeResultSet.QueryVal#
                    </cfoutput> --->
                from AllProducts
                where end_date > #Now()#
                      and state in ('AS')
        </cfquery>