| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Flow and Oracle sequence |
« View previous topic :: View next topic » |
| Author |
Message
|
| marcin.kasinski |
 Posted: Thu Jan 08, 2009 7:16 am Post subject: Flow and Oracle sequence |
 |
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
Can I use Oracle sequence in ESQL INSERT sentence or I have to use PASSTHRU ?
Code below doesn't work
| Code: |
| INSERT INTO Database.mytable (id,v1) values (mysequence_id.NEXTAL,123) |
_________________
Marcin |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Thu Jan 08, 2009 9:34 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi marcin.kasinski,
Don't even use a Passthru, else you might end up having multiple instances or flows trying to generate nextvals all over. Rather use a stored procedure on the database end, and call it.
Regards. |
|
| Back to top |
|
|
| marcin.kasinski |
| Posted: Thu Jan 08, 2009 9:44 am Post subject: |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
| elvis_gn wrote: |
Hi marcin.kasinski,
Don't even use a Passthru, else you might end up having multiple instances or flows trying to generate nextvals all over. Rather use a stored procedure on the database end, and call it.
Regards. |
Thanks for reply
I know that Passthru is not a good way.
I can do it with stored procedure. It's not a problem.
The question is : Is it possible to use this simple sentence above with sequence
| Code: |
| INSERT INTO Database.mytable (id,v1) values (mysequence_id.NEXTAL,123) |
Do I have error in this code or it is not possible to use in ESQL?
_________________
Marcin |
|
| Back to top |
|
|
| Maximreality |
| Posted: Mon Jan 12, 2009 6:33 am Post subject: |
|
|
Acolyte
Joined: 04 Jun 2004
Posts: 65
Location: Copenhagen
|
In general you can not use database specific functions in ESQL
/Rasmus |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
