thx...

i got an error code because of "SQL command not properly ended" -

it's a stored procedure creating a sequence for the DATA_YYYYMMDD table



create or replace procedure proc_seq
as
v_sql_text varchar(255);
v_seq_text varchar(512);
begin
select (max(cdr_id)+1) into v_sql_text from cdr_'|| to_char(sysdate,'YYYYMMDD') ||';
v_seq_text :='create or replace sequence cdr_id_seq incremented by 1 start with '|| v_sql_text ||'';
execute immediate v_seq_text;
end;




???

*griazi*