My Oracle Support Banner

Workarounds for bug 1400539: GETTING ORA-1461 INSERTING INTO A VARCHAR (Doc ID 241358.1)

Last updated on MARCH 12, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.6.3 to 9.2.0.8 [Release 8.0.6 to 9.2]
Precompilers - Version 8.0.6.3 to 9.2.0.8 [Release 8.0.6 to 9.2]
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2016***

Purpose

This note is applicable to 9i and lower. Note that the same ORA- error may indeed be seen in higher versions but then the root cause and conditions are different.

This note tries will describe reasons and workarounds for <Bug 1400539>. There was a extensive code rewrite done for 10.1 to eliminate the issue reported in this bug.

This bug describes the following problem:

Problem:
GETTING ORA-1461 WHEN INSERTING INTO A VARCHAR FIELD

Problem symptoms

Resulting error
ORA-1461: "can bind a LONG value only for insert into a LONG column"

Scope

There are a number of ways to "hit" this bug, and some of the workarounds can be more or less relevant depending on the exact circumstances. However, in all cases the problem will be down to using a single byte client character set and a multibyte database character set. If that is not a setup you use then this is not a problem you have hit. If you indeed have a setup like that then there is a good chance that some of the workarounds given below will solve your problem.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.