Home » Server Options » Data Guard » ORA-24333 - Zero Iteration Count (Oracle , 10g Windows)
ORA-24333 - Zero Iteration Count [message #362957] Thu, 04 December 2008 12:09 Go to next message
Shashitham Talla
Messages: 1
Registered: December 2008
Location: Chicago USA
Junior Member

Dear all
Error@ ORA-24333 - Zero Iteration Count !!!!!
Here is the program,..for my report,

Strangely I am able to run the query Successfully for my report in SQL developer and report builder and I can even give a bind parameters using both , but the requirement for this report is I should ether run this report in discoverer or xml
For that I have successfully created a report in report builder and when I create a Concurrent Program and Run It,… I get an error
ORA-24333 - Zero Iteration Count
=> with Tender As ( Select F1.Store_code as Store_Code, ……

any suggestion is greatly appreciated ….

Thanks in Advance

Cheers

With Tenders As ( Select F1.Store_code AS Store_code,
F2.Tender_type_code AS Tender_type_code,
Sum(F2.Payment_amount) As Trans_amount,
Count(F2.trx_id) as Trans_count

From ors_transactions F1
Join ors_transaction_payments F2
On F1.trx_id = F2.trx_id
Where Trunc(F1.Transaction_date) Between '01-Aug-2008' And '02-Aug-2008'

Group BY F1.Store_code, F2.Tender_type_code )


select vsd.flex_value as store_code,
vsd.description as store_name,
'Tender_Amount' As Code1,
a1.CASH as Cash,
a2.Visa as Visa

from xxrei.vw_store_details vsd ,
(Select Store_code as store_code,
sum(Trans_amount) as CASH
From Tenders
Where Tender_type_Code IN ('CASH','CHECK','Other Checks')
group by Store_code )a1,

(Select Store_code as store_code,
Trans_amount as Visa
From Tenders
Where Tender_type_Code = 'Visa/MC' )a2

where vsd.flex_value = a1.Store_code (+)
and vsd.flex_value = a2.Store_code (+)

order by vsd.flex_value ;




Re: ORA-24333 - Zero Iteration Count [message #566632 is a reply to message #362957] Tue, 18 September 2012 04:12 Go to previous messageGo to next message
aazayka
Messages: 1
Registered: September 2012
Junior Member
I have the same problem. Rewriting the query without WITH clause hepls me.
Re: ORA-24333 - Zero Iteration Count [message #566635 is a reply to message #566632] Tue, 18 September 2012 04:24 Go to previous message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just replace the name of subquery by the subquery itself everywhere you see it.

Regards
Michel
Previous Topic: STANDBY RESOURCE DEMOND
Next Topic: detecting archive log gaps
Goto Forum:
  


Current Time: Thu Nov 14 04:14:02 CST 2024