MQSeries.net :: View topic - Issue with reading blob data from Oracle to esql

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 » Issue with reading blob data from Oracle to esql

Issue with reading blob data from Oracle to esql

« View previous topic :: View next topic »

Author

Message

uzma.khaiser

Posted: Wed Jul 10, 2013 6:41 pm Post subject: Issue with reading blob data from Oracle to esql

Newbie

Joined: 20 Jul 2010
Posts: 5

Hi,

We are trying to read few column data from oracle table among which one column is blob. We are having issue when we use direct select statement from esql. We have tried the below as well to retrieve the data into esql but still facing the error/exception

1. Used passthru but it did not work
2. Used direct esql stmt , but no result set retrieved
3. Used stored proc to retrieve values, but its working only when one single row is returned. but when multiple rows are retrieved its giving error as "RESULTSET_PARM_0"

smdavies99

Posted: Wed Jul 10, 2013 9:57 pm Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

What are the errors you are getting.

Just saying you are getting an error is really not very helpful at all.

Please show us your code and the exceptionList.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

kash3338

Posted: Thu Jul 11, 2013 3:03 am Post subject:

Shaman

Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India

1. How many column's are you fetching?
2. What is your select query and the datatypes used?
3. Exception trace?

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Issue with reading blob data from Oracle to esql

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