| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| "[Oracle][ODBC]Cursor Not Updateable." on update |
« View previous topic :: View next topic » |
| Author |
Message
|
| rmurillo |
 Posted: Fri Mar 24, 2006 9:50 am Post subject: "[Oracle][ODBC]Cursor Not Updateable." on update |
 |
|
Newbie
Joined: 24 Mar 2006
Posts: 5
|
I have not written ESQL that accesses a DB before, so I'm hoping this is simple.
However, my google search and search of this forum have been fruitless, so maybe not.
I have a select, which works fine -
SET Environment.Data[]=
(SELECT T.MESSAGE, T.WBIROWID FROM Database.hl7buffer AS T
WHERE T.MESSAGECONTROLID = InputRoot.MRM.q1:HL7_SGMSA.q2:HL7_SGMSA.q2:MessageControlID);
Then there's some data manipulation, and the next DB call is
UPDATE Database.hl7buffer AS T SET MESSAGE=NewHL7Msg, DELETEDIND=NULL
WHERE T.WBIROWID = WBIROWID AND T.TARGETSESSION='WBI_LTT_ORU_SCM' AND T.DELETEDIND IS NOT NULL;
On that call, I get the error "[Oracle][ODBC]Cursor Not Updateable."
Does this ring a bell for anyone?
Thanks,
Bob |
|
| Back to top |
|
 |
| narendrach |
| Posted: Fri Mar 24, 2006 1:29 pm Post subject: |
|
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
Did u Try any other sample Update Statements ... other than this
if u try and even it is also not working ..
Then u need to set a property while configuring ur DSN
Check this Property
Enable SQLDescriberParam
_________________
Narendra CH |
|
| Back to top |
|
|
| rmurillo |
| Posted: Fri Mar 24, 2006 1:36 pm Post subject: |
|
|
Newbie
Joined: 24 Mar 2006
Posts: 5
|
narendrach, thank you for your reply.
if u try and even it is also not working ..
I have tried several variations on the update, and always get the same error
Enable SQLDescriberParam
I don't see this property in my DSN configuration. Which tab should it be under? Could I have too old a version of the ODBC driver? It is Oracle in OraNT 9.02.00.00. Also, I am using WinXP SP1.
Thanks,
Bob |
|
| Back to top |
|
|
| jbanoop |
| Posted: Sat Mar 25, 2006 12:02 am Post subject: |
|
|
Chevalier
Joined: 17 Sep 2005
Posts: 401
Location: SC
|
|
| Back to top |
|
|
| mgk |
| Posted: Sat Mar 25, 2006 7:44 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
You MUST use the DataDirect driver for Oracle included with the product.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| 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
|
|
|
|
