|DBMS_XMLGEN [message #206460]
||Thu, 30 November 2006 02:44
Registered: May 2005
Iam trying to create an XML using DBMS_XMLGEN. My PL/SQL code looks like this
CTX := DBMS_XMLGEN.newContext(sqlstring);
I want my output XML to be of this format
Now, R1, R2, R3 are generated using Oracle Sequence. R4 a database field value concatenated with static text. R5 and R6 are static text again.
I have declared a cursor, which will help me in fetching R4.
Iam struck with constructing "sqlstring" dynamically. How can I frame it in a dynamic way so that I can directly pass it to DBMS_XMLGEN.newContext? Please help me out.