| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [Oracle]ORA-24333: zero iteration count |
« View previous topic :: View next topic » |
| Author |
Message
|
| letmecheck |
 Posted: Sat Sep 10, 2011 7:23 am Post subject: [Oracle]ORA-24333: zero iteration count |
 |
|
Novice
Joined: 27 May 2011
Posts: 12
|
I am having an issue while invoking SP from WMB broker 6.0, and while searching the forum I came across the similar issue reported but My case is a little different, I can call the same procedure (which also returns the cursor) in loop. When it is invoked with different parameters I am getting the same '[DataDirect][ODBC Oracle driver][Oracle]ORA-24333: zero iteration count'
That is, If I send different messages with different service ids(one of the input to the SP), and accumulate those mesages(say 50 messages) and start the flows, SP will throw the error. But the same is not noticed for the same kind of messages(same serviceid, 50 msgs).
CALL GET_VALIDATION_DETAILS(Environment.Variables.serviceId,'ALL',Environment.ResultSetHdr.Validation[]);
CREATE PROCEDURE GET_VALIDATION_DETAILS(IN SERVICE_NAME CHARACTER,IN HDR_TYPE CHARACTER)
LANGUAGE DATABASE
DYNAMIC RESULT SETS 1
EXTERNAL NAME "%.validation_config_pack.p_get_validation";
SP is vlidating against null values for Environment.Variables.serviceId and it should throw validation error if it is null.
It seems that this issue is happening randomly. Any clue?.
Any help would be greately appriciated. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Sat Sep 10, 2011 12:09 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Any chance that Environment.Variables.serviceId might be null or non existent in any of these calls? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| letmecheck |
| Posted: Mon Sep 12, 2011 9:06 am Post subject: |
|
|
Novice
Joined: 27 May 2011
Posts: 12
|
| It should not be. let us say it happens in a rate scenario, My SP implementation also check null for serviceid and thows input exception for such case. I nver get that exception in Broker other than the error mentoned in the post. |
|
| Back to top |
|
|
| letmecheck |
| Posted: Mon Sep 12, 2011 9:10 am Post subject: |
|
|
Novice
Joined: 27 May 2011
Posts: 12
|
This is a solution from one of the earlier posts for similar issues, What does this say, i did not get it clearly.
"Even if the stored procedure can accept nulls, you can't pass them in from MB. I had to define any input parameters as empty string if I wanted to pass them in as null. Then I could call the stored procedure as many times as often as I wanted with no dreaded ORA-24333 error" |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Sep 12, 2011 9:19 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| letmecheck wrote: |
| This is a solution from one of the earlier posts for similar issues, What does this say, i did not get it clearly. |
What it seems to be saying is that the NULL datatype in WMB doesn't translate properly, reliably or at all into the NULL datatype for Oracle when passed through the ODBC connector but yields instead this error, and the previous poster worked round this by substituting an empty string for the NULL in the call.
Which seems to tie in with the suggestion of my most worthy associate that Environment.Variables.serviceId is NULL when the call is made.
_________________
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
|
|
|
|
