Hello,
I am trying to pass null dates into my stored preocedure and I get the below oracle error.
exec firm_service_pkg.GET_HOLD (118,8450027 ,1 , 0 , null , null)
ORA -20008: ORA-20008: ORA-20008: ORA-20008: Invalid Input for {1} of {2}
ORA-06512: at "C12_EDB.ERROR_PKG", line 500
ORA-06512: at "C12_EDB.MI_ADE_SERVICE_PKG", line 7169
ORA-06512: at line 1
-------------------------------
Here is a snippet of my code.
"AND T.trade_dt BETWEEN NVL(i_from_dt,null ) AND NVL(i_to_dt,null )"
How can i modify , thanks