Re: Manipulating data from long columns in PL/SQL

From: Raghavan <raghavan_at_prodigy.net>
Date: Tue, 11 Jan 2000 18:53:23 -0500
Message-ID: <85gfmu$9cam$1@newssvr03-int.news.prodigy.com>

Use LOB instead of LONG.

DBMS_LOB package has better management features.

Vishal Makhija <vishal_at_taten.com.au> wrote in message news:387A7232.14A70EA3_at_taten.com.au...
> Hi ,
>
> A simple long-type manipulation question...
>
> Since the max. length of a local variable (PL/SQL) of type long is
> 32767, how does one manipulate data from Long columns, having size
> larger than that?
>
> Also, normal string functions like length or substr, do not work
> with long types. So how does one perform those on Long datatypes?
>
> Can anyone please help?
>
> Thanks.
> --Vishal
>
>
>
>
>
Received on Tue Jan 11 2000 - 17:53:23 CST