Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06512
ORA-06512 [message #37103] Thu, 17 January 2002 15:01 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: How Oracle store number datatype internally?
Next Topic: Re: How to fix ORA-00018 maximum number of sessions exceeded
Goto Forum:
  


Current Time: Thu Mar 28 18:54:26 CDT 2024