Home » Developer & Programmer » JDeveloper, Java & XML » how to GET fld nm= prefix using DBMS_XMLGEN.GETXMLTYPE (11G)
how to GET fld nm= prefix using DBMS_XMLGEN.GETXMLTYPE [message #637262] Wed, 13 May 2015 13:41
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member

instead of this:


i want this:


but I don't see any setting to make DBMS_XMLGEN.GETXMLTYPE do this. I am guessing one of four things:

1. there is a function call for the setting I don't see (undocumented?).
2. I have to use a style sheet to dynamically convert the output as it is generated.
3. Like to @ for Attribute style, there is some other character that can be used in TYPE definitions that will tell the xml generated to use this format
4. I can't use dbms_xmlgen.getxmltype but instead need to use the sql functions like XMLELEMENT.

So who knows? Thanks, Kevin.
Previous Topic: WebService Call from Oracle Database using JPublisher
Next Topic: Is it possible to retrieve an array of pl/sql record which contain DATE elements in Java
Goto Forum:

Current Time: Tue Sep 26 03:46:22 CDT 2023