| Author |
Message
|
| JLRowe |
 Posted: Tue Feb 26, 2008 8:44 am Post subject: |
 |
|
Yatiri
Joined: 25 May 2002
Posts: 664
Location: South East London
|
You're doing something wrong, all I can think of is that your transactions are rolling back.
But remember a sequence is designed to create ascending unique values, they may not be consecutive. This is to reduce contention.
If you want sequence numbers that are guaranteed to be ascending, then use a table, it may however reduce concurrency. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Feb 26, 2008 8:49 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The last time I did something like this, I used an incrementing default value.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| chandu |
| Posted: Thu Oct 14, 2010 8:25 am Post subject: |
|
|
Novice
Joined: 05 Aug 2009
Posts: 16
|
I have a similar issue.I am using test_seq.
set environment.x = passthru('select test_seq.nextval from dual');
insert into database.schema.table(col1,col2) values (environment.x,y);
After executing it is inserting null value.
But in oracle the same query returns a value.Y not in broker passthru.Help resolve. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Oct 14, 2010 8:42 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| chandu wrote: |
| I have a similar issue. |
A moderator has already split your virtually unrelated post from this thread once! 
It's considered bad form to reopen a really old thread as it's unlikely to be the same situation - software levels change for one thing. If you're convinced it's the same problem, include a link in your post to the old thread.
It's considered even worse to have 2 threads running on the same problem. Do not do this. Do not reopen old threads.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| chandu |
| Posted: Thu Oct 14, 2010 9:38 am Post subject: |
|
|
Novice
Joined: 05 Aug 2009
Posts: 16
|
| I am sorry.I will open a new thread. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Oct 14, 2010 10:28 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| chandu wrote: |
| I am sorry.I will open a new thread. |
You already have a new thread. Are you even looking at what's happening in this forum?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Oct 14, 2010 11:50 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
|
| Back to top |
|
|
|
|
