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!

sql command not properly ended

EZGmsJun 14 2011 — edited Jun 14 2011
Hi,

I have this procedure and the OS give me an error : 'sql command not properly ended'
DECLARE 
  
  
    v_start_date DATE;
    v_end_day DATE;
    v_end_month DATE;
    v_char_date DATE;
    v_max_day DATE;
    v_max_month DATE;
    
    v_select VARCHAR2(8000);

  BEGIN
  
    SELECT last_day(to_date(sysdate - interval '1' month,'dd/mm/rrrr'))  INTO v_end_day FROM dual;
    

    SELECT to_char(last_day(to_date(sysdate - interval '1' month,'dd/mm/rrrr')),'rrrr_mm') INTO v_char_date FROM dual;
    

    SELECT max(month_revenue) INTO v_end_month 
    FROM CSCV_AGR_MONTH_REVENUE;
    

   v_select := 'SELECT max(date_) FROM CSCV_SUB_CHARGES_' || v_char_date;
    EXECUTE IMMEDIATE (v_select) INTO v_max_day;
    
    v_select := 'SELECT trunc(max(date_),''month'') FROM CSCV_SUB_CHARGES_' || v_char_date;
    EXECUTE IMMEDIATE (v_select) INTO v_max_month;
    
    dbms_output.put_line(v_max_month );
    
  
  end;  
I of it's posible I would like to know what could I do to resolve the end of the string
 v_select := 'SELECT max(date_) FROM CSCV_SUB_CHARGES_' || v_char_date;
thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2011
Added on Jun 14 2011
4 comments
268 views