How to fix the Oracle error PLS-01405: Under ANSI’s grammar, numeric data represented in exponent notationmust use an uppercase E?

In this post, you’ll learn more about the Oracle ErrorPLS-01405: Under ANSI’s grammar, numeric data represented in exponent notationmust use an uppercase E with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-01405: Under ANSI’s grammar, numeric data represented in exponent notationmust use an uppercase E

Reason for the Error PLS-01405: Under ANSI’s grammar, numeric data represented in exponent notationmust use an uppercase E

Under ANSI’s grammar, numeric data represented in exponent notation must use an uppercase “E”. Example: 3.45E-6 is ANSI, but 3.45e-6 is not.

How to fix the Error PLS-01405: Under ANSI’s grammar, numeric data represented in exponent notationmust use an uppercase E ?

You can fix this error in Oracle by following the below steps

None