Having a problem with the date parameters :: Day of month must be between 1 and last day of month
I'm facing an issue i.e. if I pass parameters to the progam it is working, But if I don't pass parameters it's not working .As mentioned below I'm getting error :
-----------> ORA-01847: day of month must be between 1 and last day of month <-------------
code is below..
DECLARE
v_from_date DATE;
v_to_date DATE;
CURSOR C_CUSTOMER
IS
SELECT cust.party_id partyid,
cust.CUSTOMER_NUMBER Customer_Number,
cust.CUSTOMER_NAME Customer_Name,
cust.PARTY_TYPE Customer_Category,
cust.STATUS STATUS,
hps.STATUS SITE_STATUS,
CUST.SALES_CHANNEL_CODE SALES_CHANNEL_CODE,
hps.party_site_number Party_site_number,