MQSeries.net :: View topic - WMQI 2.1 and Oracle 8.1.7 Problem

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 » WMQI 2.1 and Oracle 8.1.7 Problem

WMQI 2.1 and Oracle 8.1.7 Problem

« View previous topic :: View next topic »

Author

Message

mcatama

Posted: Mon Nov 11, 2002 3:20 am Post subject: WMQI 2.1 and Oracle 8.1.7 Problem

Novice

Joined: 10 Apr 2002
Posts: 17

Hi,

I'm trying to perform inserts of CLOB data into an Oracle 8.1.7 database from WMQI 2.1, but I am getting the following error:

( RTBROKER1.default ) Database error: SQL State 'HY000'; Native Error Code '1031'; Error Text '[MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-01031: insufficient privileges'.

Followed by:

( RTBROKER1.default ) Database error: SQL State 'HY000'; Native Error Code '0'; Error Text '[MERANT][ODBC Oracle 8 driver]Data inconsistency problem. Sql statement was an Insert/Update containing lob data. The lob write portion of the statement failed.'.

If I log onto the database directly as the Broker user and run the equivalent SQL insert statement it works fine. Is this is an ODBC driver error? Has anyone seen this before? And more importantly does anyone know how to solve it?

Thanks,
Alison

chrisbateman

Posted: Thu Mar 27, 2003 5:39 am Post subject:

Newbie

Joined: 10 Jan 2003
Posts: 4
Location: UK

I realise that it's some time since this post but I have recently seen a similar problem.

I only see this problem when inserting a lob into a table that is not in the schema of the user that my broker connects to Oracle as.

It appears to me that the ODBC drivers result in an insert statement that returns a reference to the lob field that is then used to update the lob value.

Granting insert on the table to the Oracle user solves the problem.

Chris

mcatama

Posted: Thu Mar 27, 2003 5:52 am Post subject:

Novice

Joined: 10 Apr 2002
Posts: 17

Thanks for that.

We have managed to solve the problem. It was very similar to what you described. The WMQI user was not the schema owner and we had granted the user INSERT rights on the table. This worked fine for tables without LOB columns and was also sufficient for that user to update the LOB table via SQL*Plus, but in order for it to work correctly from WMQI the user also required UPDATE rights on the LOB table.

Thanks,
Alison

navpav

Posted: Wed Apr 02, 2003 11:29 pm Post subject: UPLOAD DATA INTO ORACLE USING MRM

Novice

Joined: 01 Apr 2003
Posts: 12

Could any one guide us how to load the data into oracle using MRM concept.We are facing problem with upload the data into oracle and db2 database using MRM.
Please send an example or exercise so that the same thing we can replicate here...send detail step by step procedure.....

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMQI 2.1 and Oracle 8.1.7 Problem

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