Re: Should I use LOBs here? HOW???

I am not yet familiar with Oracle8. I only use it to test compatibility.
But you must know that no functions can be used with the LONG datatype. A LONG can be used in the select list of a select statement and in a set clause of
an update statement. You can't use it in a where clause.

We tried both approach (split and LONG) for different types of data. The split
option was used when we know that we need to use the data in a where clause.
But Oracle8 may offer you a better option.

Sylvain Leclerc
sleclerc_at_magrit.com

> -----Original Message-----
> From: a [SMTP:a_at_x.y]
> Posted At: Wednesday, August 05, 1998 4:25 AM
> Posted To: server
> Conversation: Should I use LOBs here? HOW???
> Subject: Should I use LOBs here? HOW???
>
> Hi,
>
> We have a reasonably simple requirement - to store a couple of pages
> of text
> per row in a table. Up til now we used VARCHAR2(4000) columns, but
> this is
> no longer sufficient.
>
> To store more, it seems I would have to use LONG or CLOB. Oracle doco
> says
> that, in V8, LONGs are provided purely for backward compatibility, and
> we
> should use LOBs instead. However, when I tried using CLOBs in our
> webserver
> app, I'm having all sorts of troubles with using the datatype in
> webserver
> procedures, and normal functions (eg UPPER).
>
> So, should I persevere with LOBs? Am I merely doing it wrong? Or
> should I
> use LONGs anyway? Or, should I pursue a different method - eg
> splitting the
> text into multiple VARCHAR chunks for storage and gluing them back
> together
> for retrieval?
>
> Any advice will be appreciated.
>
> Thanx
>
> -ak
>
Received on Wed Aug 05 1998 - 06:54:42 CDT