Subscribe Now: Feed Icon

Monday, April 8, 2013

ORA-03149: Invalid Oracle error code

Just got this error.

The only thing I saw on the web on this was: “This is an internal protocol error. Contact Oracle Support Services.”

As I see it, it means Oracle doesn’t know what I did wrong.

At the end we found out that the error was caused by entering a value of 1.7976931348623157E308 to a NUMBER(38, 8) field. The person that sent me this value meant to send NaN but at the end sent Double.MaxValue.

I am sure this is just one symptom of the problem but maybe it will help someone out there…