Skip to content
Advertisement

Insert Fail because of wrong non-numeric character

hy

table:

wrong insert:

whats wrong?

error code:

Advertisement

Answer

*Cause: The input data to be converted using a date format model was incorrect. The input data did not contain a number where a number was required by the format model.

The date string you’re using doesn’t match what oracle is expecting. The default format, iirc, is DD-Mon-YYYY, not Mon-DD-YYYY as you’re trying to use.

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement