MQSeries.net :: View topic - SQL Exception Calling Oracle Stored Procedure with XML Param

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 » SQL Exception Calling Oracle Stored Procedure with XML Param

SQL Exception Calling Oracle Stored Procedure with XML Param

« View previous topic :: View next topic »

Author

Message

junzi88

Posted: Fri Dec 18, 2015 1:05 pm Post subject: SQL Exception Calling Oracle Stored Procedure with XML Param

Novice

Joined: 25 Sep 2013
Posts: 16

Hello,

We are using WMB 8.0.0.4 and the service calls the ORACLE database stored procedure with 8.0.0.4 ODBC driver. One of OUT parameter of the stored procdure is XML data type. When the message flow to call it, it throws SQL exception:[IBM][ODBC Oracle Wire Protocol driver]Optional feature not implemented. The advanced properties are all checked, like enable N-CHAR support, Enable SQLDescibeParam, etc.

I used JAVA application to call the same stored procedure and I was able to get XML data back. So the stored procedure is fine.

Did anyone have same problem? How to solve it?

Thanks a lot

smdavies99

Posted: Fri Dec 18, 2015 1:15 pm Post subject:

Jedi Council

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

Does the IIB Documentation indicate that an XML Datatype is actually supported?
_________________
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.

junzi88

Posted: Mon Dec 21, 2015 11:17 am Post subject:

Novice

Joined: 25 Sep 2013
Posts: 16

IIB does support XML data type. I checked with our DBA and recently the ORACLE was upgraded to 11.2.0.4.8 which makes current IBM ODBC stop working. I opened PMR with IBM to request the fix for the ODBC driver.

http://knowledgebase.progress.com/articles/Article/000051928

=============Explaines as following.
Oracle made a modification in Oracle 11.2.0.4 and higher that gives an extra column description for the SQLProcedureColumns on an XMLTYPE. With versions prior to 11.2.0.4 this column description is "XMLTYPE". With version 11.2.0.4 and higher this new column description is "OPAQUE/XMLTYPE". The driver was expecting only "XMLTYPE" and returned "Unknown" due to the driver not understanding the new column description.

Note that this only affects SQLProcedureColumns and does not affect SQLColumns

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SQL Exception Calling Oracle Stored Procedure with XML Param

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