I have this script to modify sequence but failed in the line of "alter". Can I
execute alter in PL/SQL? Thanks!
declare
seq_name varchar(256);
cursor seq_cursor is
select * from dba_sequences
where sequence_owner = 'XXX';
begin
for seq_val in seq_cursor
loop
seq_name := seq_val.sequence_owner || '.' || seq_val.sequence_name;
alter sequence seq_name nocache;
end loop;
end;
Error message like:
alter sequence seq_name nocache;
*
ERROR at line 10:
ORA-06550: line 10, co
n********a 发帖数: 68
2
Use execute immediate for DDL.
execute immediate 'alter sequence seq_name nocache';
I
following:
【在 l***r 的大作中提到】 : I have this script to modify sequence but failed in the line of "alter". Can I : execute alter in PL/SQL? Thanks! : declare : seq_name varchar(256); : cursor seq_cursor is : select * from dba_sequences : where sequence_owner = 'XXX'; : begin : for seq_val in seq_cursor : loop