Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting a For Loop Value and Creating and XML in Oracle

Fiham ZuherMar 9 2016 — edited Mar 9 2016

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

This post has been answered by odie_63 on Mar 9 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2016
Added on Mar 9 2016
18 comments
1,810 views