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!

drop sequence in trigger

448590Jan 21 2011 — edited Jan 21 2011

Hello,

ich have a sequence seq1. This sequenced is used in a trigger to autoincrement.

Now I want to check in the trigger which is the actual value of the sequence and if a specific value is reached i want to drop and create the sequence completely new. But this does not work.
I have also tried to create a procedure (where the deleting is done) and to call the procedure in the trigger but I always get ora-04092.

How can I delete this sequence and create it in a trigger/procedure?

Kind Regards, Jade

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 18 2011

Added on Jan 21 2011

9 comments

763 views