OraFAQ Forum: JDeveloper, Java & XML » Usage of COUNT in template of XML Publisher

Home » Developer & Programmer » JDeveloper, Java & XML » Usage of COUNT in template of XML Publisher

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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?

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 07:10:03 CST 2024