| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| XMLType return from Oracle in MB |
« View previous topic :: View next topic » |
| Author |
Message
|
| keenlearner |
 Posted: Mon Jan 29, 2007 4:53 am Post subject: XMLType return from Oracle in MB |
 |
|
Acolyte
Joined: 24 Aug 2006
Posts: 62
|
hi guys
I am using WBIMB v6.0 on Windows XP and oracle9.
I am callling a procedure of Orcale from MB which returns XMLType.
The Code sinppet which i am using is given below.
| Code: |
CREATE PROCEDURE CLOB_Data_Return(OUT result CHARACTER)
LANGUAGE DATABASE
EXTERNAL NAME "APPS.FETCH_XMLDATA_PKG.RETURN_CLOB";
CREATE PROCEDURE XML_Data_Return(IN myINT INTEGER,OUT result CHARACTER)
LANGUAGE DATABASE
EXTERNAL NAME "APPS.FETCH_XMLDATA_PKG.RETURN_XMLType";
CREATE COMPUTE MODULE XML_Return_From_DB_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
CALL CopyMessageHeaders();
DECLARE myVar CHARACTER;
DECLARE myResult CHARACTER '';
CALL CLOB_Data_Return(myResult);
CALL XML_Data_Return(1001,myVar);
CALL XML_Data_Return(OutputRoot.XML.Employeelist);
SET myResult='<Employeelist>'||myResult||'</Employeelist>';
--SET OutputRoot.BLOB.BLOB=CAST(myResult AS BLOB CCSID InputRoot.MQMD.CodedCharSetId ENCODING InputRoot.MQMD.Encoding);
RETURN TRUE;
END;
|
The procedure which retruns Clob is running fine but the procedure which is returning XML Type is throwing error
| Quote: |
| [DataDirect][ODBC Oracle driver]Optional feature not implemented. |
Can anyone help on this. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Jan 29, 2007 4:59 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I don't think Broker supports Oracle XML Types.
Otherwise, make sure your datasource has EnableSQLDescribeParen turned on.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| keenlearner |
| Posted: Tue Jan 30, 2007 9:52 pm Post subject: |
|
|
Acolyte
Joined: 24 Aug 2006
Posts: 62
|
hi jeff
i am using the below code sinppet..
| Code: |
CREATE PROCEDURE XML_Data_Return(IN myINT INTEGER,OUT result CHARACTER)
LANGUAGE DATABASE
EXTERNAL NAME "APPS.FETCH_XMLDATA_PKG.RETURN_XMLType";
--with Main
CREATE FIELD Environment.Variables.Result;
DECLARE myRef REFERENCE TO Environment.Variables.Result;
CALL XML_Data_Return(1001,myRef);
|
i m getting following datababse exception.
| Quote: |
[DataDirect][ODBC Oracle driver]Optional feature not implemented.
|
what are the otional feature to be installed? |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jan 31, 2007 12:50 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
I think what it means is that the optional feature (Oracle XML Type I suspect) is not supported by the DataDirect ODBC driver.
I get that message (not from WMB it must be pointed out) when I'm trying something a bit ambitious.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| 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
|
|
|
|
