Re: need suggestion on handling large text fields

Hi Joe,

You don't say where the problem is, whether you are unable to select a CLOB, or if you get some other error message such as data overflow. Also, what product you are using.

My thoughts, if it is a data overflow problem within one of the access tools, ProC, SQL*Plus, Forms is that you could set the arraysize and maxdata parameters, so that only 1 row is fetched at a time. This is what we had to do with LONG's in the v7.x days.

I would be surprised if you could not say 'select CLOB from TABLE'.

Rgds
Andrew

Joe wrote:

> I need to write SQL statments that handles large text fields (no more
> than 32k). I have such fields in Sybase and need to have the same
> type of support in oracle.
>
> In sybase there is a text field that does this. I am not sure what
> the equivalent is in Oracle. I have tried using CLOB. However, with
> CLOBS, I can't seem to do a select clob_column. I get an error when I
> try to do this.
>
> I am assuming that CLOBs have the same characteristics as BLOBs which
> I know cannot be viewed with a simple select *.
>
> Unfortunately, I am using existing applications which does select *
> and this code cannot change.
>
> Any help would be greatly appreciated. Thanks.
Received on Tue Mar 30 1999 - 01:19:52 CST