| aki |
Posted: Apr 04, 2008 10:05:09 AM |
Total Post: 2
Joined: Apr, 2008
|
Hi all,
I am getting this error msg from pl/sql code:
ORA-06502: PL/SQL: numeric or value error
ORA-01401: inserted value too large for column
That's it, noting else. I can't see anything in the alert log either.
No trace files either.
I was wondering. How do I find out which value or a column is big/small.
Thanks in advance.
|
|
|
 Murtuja |
| Posted: Apr 04, 2008 10:30:08 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
Do you have access to that pl/sql code ?
|
|
|
|
|
| Mohammed Taj |
| Posted: Apr 05, 2008 02:18:23 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
Please visit.
http://www.techonthenet.com/oracle/errors/ora01401.php
|
|
|
|
|
| aki |
| Posted: Apr 09, 2008 07:54:59 AM | |
|
Total Post: 2
Joined: Apr, 2008
|
Hi guys,
I have access to that code but it is really painstaking job to find wich column is the issue and then go through 200.000 rows (in an XML file) to find the row that is to big for the column.
I toad that there is a way to trace certain events in oracle. i have managed to trace the "ORA-01401" but, there rest of the error stack missing, like which field is not accepting the value.
So if anyone knows how to do this pls. let me know.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
