| Author |
Message |
 Topic: Unable to call an oracle stored procedure |
al000y
Replies: 24
Views: 21452
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 13, 2014 11:32 am Subject: Unable to call an oracle stored procedure |
Mqjeff, thanx for your patient.
I will describe to you the situation exactly
When I used the drivers that's comes with the broker everything works fine and I got the results correctly from the pr ... |
| Topic: Unable to call an oracle stored procedure |
al000y
Replies: 24
Views: 21452
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 12, 2014 11:49 pm Subject: Unable to call an oracle stored procedure |
| It is MQSeries DataDirect 4.10 32-BIT Oracle8. |
| Topic: Unable to call an oracle stored procedure |
al000y
Replies: 24
Views: 21452
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 11, 2014 5:05 am Subject: Unable to call an oracle stored procedure |
| Any help? |
| Topic: Unable to call an oracle stored procedure |
al000y
Replies: 24
Views: 21452
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Aug 09, 2014 10:02 pm Subject: Unable to call an oracle stored procedure |
ODBC used by the node is pointing to SQORA32.DLL
the version of the file 3.51
That's the only thing that I can get. Go easy on me  |
| Topic: Unable to call an oracle stored procedure |
al000y
Replies: 24
Views: 21452
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 07, 2014 8:39 am Subject: Unable to call an oracle stored procedure |
We are using oracle drivers and it work perfectly, even for calling procedures with no in or out parameters it work great, only put IN or OUT parameters I got an exception
I will try to use the IB ... |
| Topic: Unable to call an oracle stored procedure |
al000y
Replies: 24
Views: 21452
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 07, 2014 5:58 am Subject: Unable to call an oracle stored procedure |
Broker Version 5.00
Oracle ODBC Driver version 3.51 |
| Topic: Unable to call an oracle stored procedure |
al000y
Replies: 24
Views: 21452
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 07, 2014 5:19 am Subject: Unable to call an oracle stored procedure |
Broker Version: 5.3
ODBC Oracle version 11.02 |
| Topic: Unable to call an oracle stored procedure |
al000y
Replies: 24
Views: 21452
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 07, 2014 5:08 am Subject: Unable to call an oracle stored procedure |
I defined the issue the input but I dont know the solution.
It is with mismatching data type. |
| Topic: Unable to call an oracle stored procedure |
al000y
Replies: 24
Views: 21452
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 07, 2014 3:48 am Subject: Unable to call an oracle stored procedure |
| I tested the procedure in SQLDEveloper, it works fine. |
| Topic: Unable to call an oracle stored procedure |
al000y
Replies: 24
Views: 21452
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 06, 2014 10:03 am Subject: Unable to call an oracle stored procedure |
ok it's and I cannot upgrade it 
Please help |
| Topic: Unable to call an oracle stored procedure |
al000y
Replies: 24
Views: 21452
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Aug 03, 2014 10:03 pm Subject: Unable to call an oracle stored procedure |
Hi All,
I'm trying to call an oracle stored procedure from my flow, I'm using websphere 5.1.
I'm getting this exception
CREATE COMPUTE MODULE TestCallProcedure_Compute
CREATE FUNCTION Main&# ... |
| Topic: vb.net MQ API CCSID problem |
al000y
Replies: 12
Views: 18174
|
Forum: IBM MQ API Support Posted: Mon Jun 23, 2014 8:11 pm Subject: vb.net MQ API CCSID problem |
Do I have to change the writing function msg_MQSV_IN.WriteString("TEST") to something different or there is another thing that I have to do?
Your function uses WriteString, and then assum ... |
| Topic: vb.net MQ API CCSID problem |
al000y
Replies: 12
Views: 18174
|
Forum: IBM MQ API Support Posted: Mon Jun 23, 2014 5:21 am Subject: vb.net MQ API CCSID problem |
| So you mean to say the input message is lying about the CCSID of it's content... Nothing new there. You need to get back to the input group and make sure they adequately describe the CCSID of the mess ... |
| Topic: vb.net MQ API CCSID problem |
al000y
Replies: 12
Views: 18174
|
Forum: IBM MQ API Support Posted: Mon Jun 23, 2014 5:07 am Subject: vb.net MQ API CCSID problem |
| So you mean to say the input message is lying about the CCSID of it's content... Nothing new there. You need to get back to the input group and make sure they adequately describe the CCSID of the mess ... |
| Topic: vb.net MQ API CCSID problem |
al000y
Replies: 12
Views: 18174
|
Forum: IBM MQ API Support Posted: Mon Jun 23, 2014 3:18 am Subject: vb.net MQ API CCSID problem |
This is the test code, the input is TEST
DECLARE NAME1 CHAR CAST(InputRoot.BLOB.BLOB as char CCSID InputRoot.Properties.CodedCharSetId Encoding InputRoot.Properties.Encoding);
DECLARE ... |
