Home » Developer & Programmer » JDeveloper, Java & XML » Usage of COUNT in template of XML Publisher
Usage of COUNT in template of XML Publisher [message #221537] Tue, 27 February 2007 06:22
orafan2003
Messages: 122
Registered: February 2006
Senior Member
Hi, I am using the following query in my MS Word template so that I can use this in my Xml Publisher.
select country_name,count(country_name)
from prod1 p1,prod2 p2,country cnt
WHERE p1.country_code=cnt.country_code(+)
and p1.sc=p2.sc(+)
and cnt.region = 'US'
group by country_name;
I am getting an error. I observed that the usage of COUNT is causing the error. Can we not use functions like COUNT, DECODE(There is another query on DECODE which is giving an error). How can I achieve this task of getting the COUNT?

Previous Topic: typing a java class that return array , and i control it in an oracle procedure ?????
Next Topic: Procedure Call Problem
Goto Forum:
  


Current Time: Thu Mar 28 17:43:52 CDT 2024