Skip to Main Content

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-01843: not a valid month

mist123Apr 25 2024

Hello,

Oracle 11.2

I will need to pass date datatype parameter to the package.

Executing package manually in SQL Developer tool.

Begin
xxc_test_pkg.main(p_from_date=>'01-DEC-2023', p_to_date=>'31-DEC-2023');
End;

Inside the package, code has...
p_from_date,l_cutoff_date are the DATE

IF NVL (p_from_date, '01/21/2017') >= NVL (l_cutoff_date, '01/21/2017')

but getting ORA-01843: not a valid month error..
Comments
Post Details
Added on Apr 25 2024
4 comments
203 views