Home » Developer & Programmer » Reports & Discoverer » regarding use of xmlelement in report 6i (d2k 6i)
regarding use of xmlelement in report 6i [message #570178] Tue, 06 November 2012 05:48 Go to next message
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.
Re: regarding use of xmlelement in report 6i [message #570180 is a reply to message #570178] Tue, 06 November 2012 06:01 Go to previous message
Littlefoot
Messages: 19809
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.
Previous Topic: error importing business area/folder using eulapi
Next Topic: Paper Layout only converting to web layout
Goto Forum:
  


Current Time: Wed Nov 26 10:32:15 CST 2014

Total time taken to generate the page: 0.09403 seconds