Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle long datatype with NVL() in insert statement
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.
Received on Mon Oct 03 2005 - 12:38:16 CDT