drop and create sequence from a stored procedure

[liorjsb]

Thanks

I used dbms_sql.parse which worked:


FUNCTION GET_SEQ_FN
RETURN NUMBER IS
cur_id NUMBER;
BEGIN
cur_id := DBMS_SQL.OPEN_CURSOR;
dbms_sql.parse(cur_id,'DROP SEQUENCE TEST',dbms_sql.v7);
dbms_sql.parse(cur_id,'CREATE SEQUENCE TEST START WITH '||v_bid_objId||' INCREMENT BY 1 NOCACHE',dbms_sql.v7);
DBMS_SQL.CLOSE_CURSOR(cur_id);
END;

Thanks again.