Home » SQL & PL/SQL » SQL & PL/SQL » error while inserting into table (oracle 10g)
error while inserting into table [message #352363] Tue, 07 October 2008 06:08 Go to next message
Messages: 70
Registered: September 2008
Location: New Delhi, India
I m trying to insert values from a cursor to a very large table containing around 500 columns.I m getting following error

ORA-01438: value larger than specified precision allowed for this column Backtrace Info:: ORA-06512: at "PROC_MST_CARD_TEST", line 162

Is there any way through which I can find out at which column error is coming.Debugging through this large table seems to be very time consuming.

Re: error while inserting into table [message #352369 is a reply to message #352363] Tue, 07 October 2008 06:26 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way in 10g, upgrade in 11g.

And error in SQL is NOT a Performance question.


[Updated on: Tue, 07 October 2008 06:26]

Report message to a moderator

Previous Topic: How to Pass array of values in Stored Procedures
Next Topic: date conversion
Goto Forum:

Current Time: Fri Oct 21 19:40:12 CDT 2016

Total time taken to generate the page: 0.09373 seconds