Drop and Recreate Sequence Numbers during Migration

Drop and Recreate Sequence Numbers during Migration
Stored procedure to drop and recreate sequence numbers during migration from one environment to another.

CREATE or REPLACE PROCEDURE reset_seq(p_statement_txt1 varchar2, seq_name varchar2, p_statement_txt2 varchar2, seq_number number)IS cursor_handle number:=DBMS_SQL.OPEN_CURSOR; rows_processed number:=0; statement_txt varchar2(500);BEGIN statement_txt := p_statement_txt1 ' 'seq_nameP_statement_txt2' 'seq_number; dbms_output.put_line(statement_txt); DBMS_SQL.PARSE (cursor_handle, statement_txt, DBMS_SQL.NATIVE); rows_processed := DBMS_SQL.EXECUTE(cursor_handle); DBMS_SQL.CLOSE_CURSOR(cursor_handle);EXCEPTION WHEN OTHERS THEN IF DBMS_SQL.IS_OPEN(cursor_handle) THEN DBMS_SQL.CLOSE_CURSOR(cursor_handle); END IF; RAISE;
END reset_seq;