Skip to Main Content
Forums

Database Software

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!

Generating XML from dual

sreeseNov 6 2008 — edited Jan 6 2009
Hey Gurus,

I'm trying to generate the following XML from dual, however, I keep getting an error message stating my top level is not defined. Any ideas? Thanks!

<PUDOOUTPUT>
<PKG>
<SHIPMENTID>12345</SHIPMENTID>
<ERROR>'NO DATA'</ERROR>
<ERRORTEXT>'Error: Cannot find shipper alias in SPL_SHIPPER_ACCOUNTS.'</ERRORTEXT>
</PKG>
</PUDOOUTPUT>



select xmlelement("PUDOOUTPUT",xmlelement("PKG",xmlelement("SHIPMENTID",i.shipmentid),
xmlelement("ERROR",'NO DATA'),
xmlelement("ERRORTEXT",'Error: Cannot find shipper alias in SPL_SHIPPER_ACCOUNTS.')))
into p_wms_output
from dual;
This post has been answered by Jason_(A_Non) on Nov 7 2008
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 3 2009
Added on Nov 6 2008
#error, #performance-availability, #pl-sql, #plsql, #sql, #xml, #xml-db
2 comments
1,074 views