MQSeries.net :: View topic - inserting a BLOB into Oracle

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » inserting a BLOB into Oracle

inserting a BLOB into Oracle

« View previous topic :: View next topic »

Author

Message

fjcarretero

Posted: Tue Dec 16, 2003 10:35 am Post subject: inserting a BLOB into Oracle

Voyager

Joined: 13 Oct 2003
Posts: 88

Hi all,

I have a problem when I try to insert a message into a BLOB in an Oracle Database.
The error I'm getting is [MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-01465: invalid hex number.

This is the ESQL that I'm using
INSERT INTO Database.MSG_STORE (MSGID,MSGDATA)
VALUES (CAST(Root.MQMD.MsgId AS CHAR),Root.BLOB.BLOB);

It works in NT but it doesn't work in Solaris.

I'm using Oracle 9 and WMQI v2.1

Thank you.

EddieA

Posted: Tue Dec 16, 2003 12:50 pm Post subject:

Jedi

Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles

It might be the MSGID part. The CAST will output the MSGID with |x'| at the front of the string and |'| at the end (used pipe, so quotes show up clearer). Maybe you need to SUBSTRING it FROM 3 FOR 48.

Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0

fjcarretero

Posted: Tue Dec 16, 2003 3:01 pm Post subject:

Voyager

Joined: 13 Oct 2003
Posts: 88

Hi Eddie,

Thank you very much for your response. I should have given more information about the table
MSGID is defined as VARCHAR
MSGDATA is defined as BLOB.

I have made another test with another table. This new table has MSGDATA defined as CLOB. If I cast the Root.BLOB.BLOB to char it works.
I think is something related to the installation of Oracle.

Thanks
Felipe

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » inserting a BLOB into Oracle

Jump to:

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

Protected by Anti-Spam ACP