Re:Manipulating Long Raw in Pl/Sql

From: Phil Preen <obiwan-preen_at_maytheforcebewithyou.co.uk>
Date: Tue, 11 Jan 2000 11:04:04 -0000
Message-ID: <947588814.549076@red.parallax.co.uk>

Vishal Makhija <vishal_at_taten.com.au> wrote in message news:387A71EB.CF6847EF_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?
>

The answer is that you do not use PL/SQL, as it is not designed for handling long/binary data in this way. Use some other more suitable language like C/C++. Alternatively, re-think your database design. If you really need to manipulate data within a long raw column, it probably shouldn't be a long raw column. Consider splitting it into several VARCHAR (or other type) columns instead, or possibly another table entirely.

Phil. Received on Tue Jan 11 2000 - 05:04:04 CST