PL/SQL (MOSC)

MOSC Banner

Having a problem with the date parameters :: Day of month must be between 1 and last day of month

edited Oct 17, 2012 1:56AM in PL/SQL (MOSC) 21 commentsAnswered ✓
Hi All,

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center