OraFAQ Forum: Reports & Discoverer » regarding use of xmlelement in report 6i

Home » Developer & Programmer » Reports & Discoverer » regarding use of xmlelement in report 6i (d2k 6i)

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

regarding use of xmlelement in report 6i [message #570178]

Tue, 06 November 2012 05:48

neerumishra
Messages: 6
Registered: November 2012
Location: delhi

Junior Member

hello every one i want to display values of same column with comma seperation like this

SELECT RTRIM(XMLAGG(XMLELEMENT(e,DESCR_INDI || ',')).EXTRACT('//text()'),',') INTO DESCR FROM
STUDENT_SKILL_PER WHERE GROUP_NAME=:GROUP_NAME
AND SKILL_NAME=:SKILL_NAME AND SUB_SKILL_NAME=:SUB_SKILL_NAME
AND TERM=:TERM AND STUDENT_CODE=:STUDENT_CODE AND YEAR_CD=:YEAR_CD;
but the error shown to me that xmlelement must be declared...
but when i deploy same query at sql editor it gives me correct result..
can any one help me out how i can use it on oracle report 6i...
i am using oracle 9i as database.

Report message to a moderator

Re: regarding use of xmlelement in report 6i [message #570180 is a reply to message #570178]

Tue, 06 November 2012 06:01

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'd say that Reports 6i is too old to support XML features you are using.

A workaround is to create a database function which would return the result into the report. Pass all parameters you used in this query.

Report message to a moderator

Previous Topic:	error importing business area/folder using eulapi
Next Topic:	Paper Layout only converting to web layout

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 11 18:47:10 CDT 2025