Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Sequence drop does not work sometime
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 Wed Oct 17 2001 - 23:44:08 CDT
![]() |
![]() |