Home » SQL & PL/SQL » SQL & PL/SQL » exception for field width (Oracle 10g)
exception for field width [message #636874] Mon, 04 May 2015 12:54 Go to next message
m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman
Senior Member
i am using ole for uploading excel data into one of tables , while inserting i found out an error ora-106553 , and later on when i checked the length of one cell having length of 13 characters, which i was trying to insert into a column of length 12 varchar, is there any exception handler which we can use to handle this situation to be aware of it.

Report message to a moderator

Re: exception for field width [message #636875 is a reply to message #636874] Mon, 04 May 2015 13:01 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

When all else fails Read The Fine Manual

https://docs.oracle.com/database/121/SQLRF/statements_9014.htm#SQLRF01604

Report message to a moderator

Previous Topic: PIVOTING: one row to multiple columns
Next Topic: Update record based on previous record
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 22:44:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.