jimmy.brock wrote:
> Sybrand,
>
> I like #1 best. But I don't think management would go for it. The
> reporting tool we are using is SQR, which has an issue with CLOB data
> types. Ironically, SQR is owned by PeopleSoft - which means SQR is an
> Oracle company.
>
> Thanks - appending data into the LONG column seems like the best
> solution. I really don't want to use Java to fix this issue.

Then expect the version of the tool you are using to be dumped in 2008.
Oracle has a low tolerance for such nonsense.
Doesn't mean it doesn't exist.
But the tolerance is still quite low.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org