Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Sequence drop does not work sometime

Sequence drop does not work sometime

From: Pinto <reach_me_at_india.com>
Date: Thu, 18 Oct 2001 10:14:08 +0530
Message-ID: <9qlmjp$fgj$1@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 Wed Oct 17 2001 - 23:44:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US