query of queries and large data types

[jim1234]

I am performing a query of queries against a query the selects a clob value
from an Oracle database. When I try to access the clob value in the query of
queries I receive the following error message:

Query Of Queries runtime error.
Failed to get meta_data for columnserver.listItems.Text_Value

This is on ColdFusion 7 with Windows 2000.

Thanks,
Jim

[jim1234]

Apparently ColdFusion 7 query of queries just won't handle and columns larger
than a certain size. I tried converting the clob value to a char (using
oracle's to_char) and query of queries still wouldn't take it. The error
message now is:

"Bigger type length than Maximum"

Even though the largest value is only 1027 characters.

So I guess I'm screwed as far as using any of the ColdFusion features for
caching any data since you can't use cfqueryparam within a cached query either.

But if anyone has any other insight, it would be appreciated.

Jim