| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Storing XML as CLOB |
« View previous topic :: View next topic » |
| Author |
Message
|
| satnam |
 Posted: Fri Nov 14, 2003 9:31 am Post subject: Storing XML as CLOB |
 |
|
Newbie
Joined: 20 May 2003
Posts: 7
|
Hi
I am tring to execute the following statement in WMQI database node
PASSTHRU('INSERT INTO STORAGE(
ID,XML)
VALUES (?,?)' , id ,BITSTREAM("Body"));
here is my table definition
ID NOT NULL NUMBER(10)
XML CLOB
I am using WMQI Integration Broker v 2.1 CSD 5
Database Oracle 8.1
While executing this statement I get following error
DatabaseException BIP2322E: Database error: SQL State 'HY104';
Native Error Code '0'; Error Text '[MERANT][ODBC Oracle 8 driver]Invalid precision value. Error in parameter 2.'.
The size od the XML message is around 8K
Please Advice |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Nov 14, 2003 10:23 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
First off, you should be using ASBITSTREAM instead of BITSTREAM. ASBITSTREAM is documented in the readme file.
Secondly, if you're inserting into a CLOB, you should probably be casting the result of ASBITSTREAM into a CHARACTER type instead of trying to insert a BLOB type.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| satnam |
| Posted: Fri Nov 14, 2003 10:40 am Post subject: |
|
|
Newbie
Joined: 20 May 2003
Posts: 7
|
Thanks for the recommendation .I tried using ASBITSTREAM and casting the result of ASBITSTREAM into a CHARACTER but I get the same results
Thanks |
|
| 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
|
|
|
|
