ORA-06512 [message #37103] |
Thu, 17 January 2002 15:01 |
Paul
Messages: 164 Registered: April 1999
|
Senior Member |
|
|
I am inserting records into a table using a package and an Insert with many fields. sometimes I get this error:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 1
The interesting part is that I validate all data against the database for type and size mismatches. Obviously I'm missing something. Does anyone know what an ORA-06512 error is? I understand the ORA-06502 error, but I'm hoping to gain some additional help from the 06512. For example if it meant Invalid Date, that would help a lot!
Thanks,
Paul
|
|
|
Re: ORA-06512 [message #37111 is a reply to message #37103] |
Fri, 18 January 2002 04:49 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
this error occurs normally when
1) length of assigned or selected value exceeds variable data length.
2) converting using to_number function
ex:
to_number('A1')
|
|
|
Re: ORA-06512 [message #39141 is a reply to message #37103] |
Wed, 19 June 2002 22:43 |
Dirk Ringoir
Messages: 1 Registered: June 2002
|
Junior Member |
|
|
I have received this error before. It was caused by an acces-rights problem, after I granted the rights directly, instead of a ROLE, to the user the problem was solved.
|
|
|