Hallo !
My PL/SQL -Script send me a Error-Message.
I don't know how i find the error.
i want add a new range partition in a existing table ?



declare
v_date date;
v_part varchar2(20);

CURSOR context_date_cur IS
Select distinct ext_frontend.context_date
from ext_frontend;


begin
-- Test statements here
IF NOT context_date_cur%ISOPEN
THEN
OPEN context_date_cur;
END IF;

LOOP

FETCH context_date_cur into v_date;
exit when context_date_cur%NOTFOUND;
DBMS_OUTPUT.put_line(to_char(v_date));
v_part :='part_'||(to_char(v_date));
DBMS_OUTPUT.put_line(v_part);
execute immediate 'alter table LOG_ANALYSE.FRONTEND_TAB
add partition v_part
values less than 1+to_date(v_date, DD.MM.YYYY); ';

end loop;
CLOSE context_date_cur;

end;