Stack Overflow
Stack Overflow

Questions tagged [ora-12899]

ORA-12899 Error value too large for the column

ORA-12899 Error value too large for the column

Cause:

An attempt was made to insert or update a column with a value which is too wide for the width of the destination column. The name of the column is given, along with the actual width of the value, and the maximum allowed width of the column. Note that widths are reported in characters if character length semantics are in effect for the column, otherwise widths are reported in bytes.

Action:

Examine the SQL statement for correctness. Check source and destination column data types. Either make the destination column wider, or use a subset of the source column (i.e. use substring).

18 questions
23
votes
9 answers

Best way to shorten UTF8 string based on byte length

A recent project called for importing data into an Oracle database. The program that will do this is a C# .Net 3.5 app and I'm using the Oracle.DataAccess connection library to handle the actual inserting. I ran into a problem where I'd receive…
Michael La Voie
  • 27,772
  • 14
  • 72
  • 92
7
votes
7 answers

SQL Error: ORA-12899: value too large for column

I have created the following table CREATE TABLE Customers( CustomerID varchar2(9) PRIMARY KEY, Customer_Contact varchar2(40) NOT NULL, Address varchar2(20) NOT NULL, Post_Code varchar2(7) NOT NULL, Telephone_Number varchar2(11) NOT…
Deej
  • 5,334
  • 12
  • 44
  • 68
4
votes
2 answers

How can I truncate data to fit into a field using SQL*Loader? (ORA-12899)

Using Oracle SQL*Loader, I am trying to load a column that was a variable length string (lob) in another database into a varchar2(4000) column in Oracle. We have strings much longer than 4000 characters, but everyone has agreed that these strings…
John
  • 41
  • 1
  • 1
  • 3
4
votes
2 answers

ORA-12899 error in CHAR(1) field, but I'm sending only a 'C'

My Oracle database returns the error: ORA-12899 - Value too large for column TIT.ESTADO_CIVIL (actual: 2, maximum: 1) But I'm very sure that the sended value is an unique char 'C'. Anyone knows why this is happening? (I'm using C# with…
Keyo
  • 119
  • 2
  • 8
2
votes
1 answer

Transaction does not roll back when using Spring 3 @Transactional annotation

I am using the Spring (version 3.0) '@Transactional' annotation in order to demonstrate transaction support in Spring but can't get this working (despite having seen similar issues people have encountered in this and other technical forums). Here…
user665909
  • 51
  • 1
  • 2
1
vote
2 answers

How to change Oracle 10gr2 express edition's default character set

I installed oracle 10gr2 express edition on my laptop. when I import a .dmp file which is generated by oracle 10gr2 enterprise edition, error occurs. the database server which generated the .dmp file is running with GBK charset, but my oracle…
CaiNiaoCoder
  • 3,269
  • 9
  • 52
  • 82
1
vote
1 answer

ORA-12899 after object table update

UPDATE ta_1 SET v_1 = 'new value' WHERE v_1 = 'value'; UPDATE ta_1 SET v_1 = 'newest value'; First update query returns exception ORA-12899 and second doesn't when executed on this table: CREATE OR REPLACE type t_2 AS object (v_1 VARCHAR2…
Tomas
  • 11
  • 1
1
vote
1 answer

NTEXT on SQL Server to NVARCHAR2(2000) on Oracle (ORA-12899: value too large for column)

My source is in SQL Server and the target is Oracle. There are some tables having columns defined NTEXT in SQL Server and I created columns of NVARCHAR2(2000) which allows 4000 bytes, to store the data from the source. When I pull the data defined…
llearner
  • 37
  • 5
1
vote
1 answer

Delphi getting Oracle error ORA-12899 Error value too large for the column

I have a database in Oracle. The client application is written in Delphi. When I enter values into the DBGrid which is connected to a table in the database I get "ORA-12899 Error value too large for the column".The datatype of the column specified…
Mikayil Abdullayev
  • 12,117
  • 26
  • 122
  • 206
1
vote
5 answers

Oracle SYSDATE question for datetime column ORA 12899

I wrote a trigger in which I have a line: SELECT * INTO :NEW.EVENTDATE FROM (SELECT SYSDATE FROM DUAL); For some reason this does not work (EVENTDATE column has timestamp(0) type). When I try to insert something I get error message…
Nickolodeon
  • 2,848
  • 3
  • 23
  • 38
1
vote
2 answers

ORA-12899: value too large for column, even if value in Exception is smaller

I'm getting an ORA-12899 Error when updating Entities in the DB via EclipseLink. The Exception reads as follows: RuntimeException caught: org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception…
czo02
  • 33
  • 2
  • 8
1
vote
3 answers

ORACLE capture exception object

Hi there any way to capture the objects (such as table and column) where an exception was thrown in ORACLE? I need to determine the object name to customize the error message showing the user the name of the table and field where the exception…
RRUZ
  • 134,889
  • 20
  • 356
  • 483
1
vote
1 answer

ORA-12899, while actual value length is smaller than maximum

I've loaded some data using SQL*Loader and obtained following strange error messages: ORA-12899: value too large for column AELS_AENDBESCHR (actual: 69, maximum: 70) ORA-12899: value too large for column AELS_AENDBESCHR (actual: 70, maximum:…
Liebster Kamerad
  • 6,179
  • 2
  • 19
  • 18
0
votes
1 answer

SQL Server to Oracle migration - ORA-12899: value too large for column

While migrating a SQL Server database to Oracle, I end up with an error ORA-12899: value too large for column though the datatypes are the same. This is happening with strings like 'enthält'. The data type NVARCHAR(7) should be able to hold the…
subash
  • 69
  • 2
  • 5
0
votes
2 answers

ORA-12899 Error Too large String for Same column but success different tables

I am updating string to column of length 35 into two tables first table update was success but second table give ORA error ORA-12899 Error Too large String select length('Andres Peñalver D1 Palmar Sani salt') bytes from dual; …
nithin ravi
  • 3
  • 1
1
2