Guest_imported
New member
- Jan 1, 1970
- 0
hello,
strange things are happening, and I am not even sure if the problems lies in my code, ODBC or Oracle8i!
In my code, I often need a new sequence, so, to be sure it does not exist, I first try to drop it (in try-catch block),
and then immediately create it... (This is btw how Oracle Documentation suggests it)
Now, everything goes fine "for a couple of hours", but eventually it WILL fail. What happens is that when my code creates a new sequence, no exception is thrown, so I assume the sequence was created, but it is not! As a result, the first query I use the sequence fails off course....
:-(
I tried a lot of things, maybe somebody has better ideas?
Thanks in advance!
Castellano Salvatore
(big company in europe)
strange things are happening, and I am not even sure if the problems lies in my code, ODBC or Oracle8i!
In my code, I often need a new sequence, so, to be sure it does not exist, I first try to drop it (in try-catch block),
and then immediately create it... (This is btw how Oracle Documentation suggests it)
Now, everything goes fine "for a couple of hours", but eventually it WILL fail. What happens is that when my code creates a new sequence, no exception is thrown, so I assume the sequence was created, but it is not! As a result, the first query I use the sequence fails off course....
:-(
I tried a lot of things, maybe somebody has better ideas?
Thanks in advance!
Castellano Salvatore
(big company in europe)