SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I alter a sequence in a procedure

283279May 31 2002

I need to alter sequences in a procedure. I have done this before on an Oracle 8 database using:
EXECUTE IMMEDIATE ('ALTER SEQUENCE OFFICIAL_ID_SEQ INCREMENT BY ' ||( v_official_id_high - v_official_id_current));

How do I do this on an Oracle 7 database?

Thanks,
Alison.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2002

Added on May 31 2002

2 comments

792 views