I want to create a procedure that creates then drops a sequence (the actual procedure does a lot more but this is the part that does not work).
So I assumed that I would use the following:
create or replace procedure create_then_drop_seq is
create sequence my_seq
start with 1
increment by 1
drop sequence my_seq;
But when I try and execute the procedure it does not work. Even though the lines of code in the procedure work when I input them raw into the SQL console?
Hopefully there will be a nice and simple answer to this question (he says with fingers crossed!).