I have users that need to query a table that has a CLOB column. They have to use BRIO to query. However, BRIO can NOT query CLOB datatypes.

What can I do to facilitate this?

I was thinking of creating a view. Or, I can duplicating the table into one that converts into one with a varchar datatype (since they just query for reporting).

In either case, I would have to know how to convert a CLOB into another datatype (preferrably, varchar).

One: could someone tell if I can convert it that datatype in creating the view?

Two: how would I go about converting the column (in any way possible)?

any takers?