Oracle/PLSQL: ORA-01843 Error

Oracle/PLSQL: ORA-01843 Error

Today when I was developing Oracle Form in Oracle Form Builder I got the error

"Oracle/PLSQL: ORA-01843 Error" when I googled this error I found the following solution on www.techonthenet.com

Actually I was assigning the string value to date type column as illustrated below:

Oracle/PLSQL: ORA-01843 Error

:MS_HEADER.CREATION_DATE := '11/15/2012 15:03:34';

but it should be as follows:

:MS_HEADER.CREATION_DATE := to_date('11/15/2012 15:03:34','mm/dd/rrrr hh24:mi:ss');

solution is below:

Oracle/PLSQL: ORA-01843 Error

Error Message

ORA-01843: not a valid month

Cause of Error

You entered a date, but the month portion of the date was not a valid month.

Resolution

The option(s) to resolve this Oracle error are:

1. Re-enter the date value using either a MONTH format mask.

The valid values for month are:

January, February, March, April, May, June, July, August, September, October, November, December.

Or you could use the MON format mask and use one of the following values:

Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.

If all else fails, you may want to consider using the to_date function and specifying the date format mask.

ref:http://www.techonthenet.com/oracle/errors/ora01843.php