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..