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