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
navneet_sharma
Messages: 70
Registered: September 2008
Location: New Delhi, India
Member
hi,
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.

Regards,
Navneet
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: 64131
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.

Regards
Michel

[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: Wed Dec 07 14:23:05 CST 2016

Total time taken to generate the page: 0.08465 seconds