Re: Sequence drop does not work sometime

Hello Marc,
Thats exactly why i am bit confused because, the sequence is dropped using the same session that created it, there is no question of insufficient previlege coming in. also this is succeeding 99% of the time. during a long run when may be this code is executed 1000 times, sometimes this sequence is not dropped. so u can understand, there is no question of wrong syntax or specifying wrong owner because it is succeeding 99% of the time. why is it failing sometimes???

thanks and regards,
Pinto.

Pinto <reach_me_at_india.com> wrote in message news:9qlmjp$fgj$1_at_news.mch.sbs.de...
> Hello,
> I have a vc++ code that creates a table in the database and also a
> corresponding sequence for that table. after all the inserts and updates,
at
> the end of the code, i drop the sequence. next time when the code is
> executed, if the same table is given as i/p parameter, the sequence is
> created with start with of the sequence same as the max+1 value available
in
> the table. if it is a different table, a new sequence is created.
> the problem is that the sequence drop statement fails sometime. what can
be
> the reason for the drop sequence operation to fail.
>
> warm regards,
> Pinto.
>
>
>
Received on Thu Oct 18 2001 - 08:01:54 CDT