Re: Oracle long datatype with NVL() in insert statement

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 03 Oct 2005 20:49:02 +0200
Message-ID: <dhrtv8$5ve$4@news6.zwoll1.ov.home.nl>

sameergn_at_gmail.com wrote:
> Hi,
>
> I have observed that insert statement using NVL function fails if a
> long variable's length is more than 4000.
>
> insert into some_table values (NVL(longvar, ''))
>
> The error message is ORA-01461: can bind a LONG value only for insert
> into a LONG column.
>
> Is there any foolproof way of using NVL with long datatype? (Other than
> initializing it with empty string '')
>
> Thanks,
> Sameer.
>

Not using LONGs? It's been in the Programmers Manual since the 8.0 days: do *NOT* use LONGs for new projects; use LOBs instead

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Mon Oct 03 2005 - 13:49:02 CDT