SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01850: hour must be between 0 and 23

876731Jul 20 2011 — edited Jul 21 2011

Hi techies,

We have created a procedure for our daily report.its running fine for two location.when we run for a location we end up with this error.our current NLS_DATE_FORMAT is HH24:MI:SS.but its running successfully when we set nls_date_format='DD-MON-YY'.whereas other two (Which is same except a table from where it fetch data thru dblink) running properly with NLS_DATE_FORMAT is HH24:MI:SS.

ORA-01850: hour must be between 0 and 23
ORA-02063: preceding line from DW_TO_DIRC.NACALOGISTICS.COM
ORA-06512: at "OTSLGWEB.DAILY_JOB_PROFIT_REPORT_USA", line 89
ORA-06512: at line 1

This post has been answered by Vivek L on Jul 21 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2011

Added on Jul 20 2011

#pl-sql

6 comments

2,756 views