I have a For Loop. I need to get the Assigned value to the Variable one at a time and create the XML as below.
FOR i IN varField.first .. varField.last LOOP
varColumnField:=varField(i);
END LOOP;
SELECT APPENDCHILDXML(Final_varXml, '/OBJECT/ReportViewer',(SELECT XMLELEMENT("ReportViewerReportViewDataFieldsList",
XMLAGG(XMLELEMENT ("ReportViewerReportViewDataFields",
XMLFOREST (varColumnField AS "Name",
2 AS "Type")
)))
FROM DUAL)) INTO varXml FROM DUAL;
Example Xml be Like this
<OBJECT>
<ReportViewer>
<ReportViewerReportViewDataFieldsList>
<ReportViewerReportViewDataFields>
<Name>ColumnField1</Name>
<Type>2</Type>
</ReportViewerReportViewDataFields>
<ReportViewerReportViewDataFields>
<Name>ColumnField2</Name>
<Type>2</Type>
</ReportViewerReportViewDataFields>
<ReportViewerReportViewDataFields>
<Name>ColumnField3</Name>
<Type>2</Type>
</ReportViewerReportViewDataFields>
</ReportViewerReportViewDataFieldsList>
</ReportViewer>
For Tag Value must Come from the Loop