tag:blogger.com,1999:blog-1271763227002553835.post8634376087719945994..comments2024-03-26T08:42:34.744+01:00Comments on Notes on Oracle: Creating an XMLType based on Object TypesAlex Nuijtenhttp://www.blogger.com/profile/06345615264010120428noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1271763227002553835.post-26293945889534653082011-11-05T19:34:53.983+01:002011-11-05T19:34:53.983+01:00I wasn't aware of this concept but its good to...I wasn't aware of this concept but its good to know that we can use Object types for creating XML types. The code given for this seems quite lengthy and bit difficult but I am going to try it as it will make my task easy.sap solution managerhttp://www.panayainc.com/noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-12791699435950515982011-06-16T11:53:23.538+02:002011-06-16T11:53:23.538+02:00Hi Alex,
Good post and more informative.
Thanks!...Hi Alex,<br /><br />Good post and more informative.<br /><br />Thanks!<br /><br /><a href="http://www.suneratech.com/" rel="nofollow"> Oracle Applications</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-85241615667540653422010-12-23T16:39:13.800+01:002010-12-23T16:39:13.800+01:00Hi Matt,
Thank you for this link, I didn't kn...Hi Matt,<br /><br />Thank you for this link, I didn't know that. There are a number of possibilities with the XMLType. One other very powerful way is by passing a Ref Cursor as an argument.<br /><br />AlexAlex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-37269087982425885852010-12-23T14:39:35.015+01:002010-12-23T14:39:35.015+01:00Hi Alex
Great post, its quite handy to know we ca...Hi Alex<br /><br />Great post, its quite handy to know we can use object types. Another good alternative for generating XML hierarchy structures without too much pain is DBMS_XMLGEN.newContextFromHierarchy. The following URL is a good reference point: http://awads.net/wp/2007/02/20/an-easy-way-to-convert-a-hierarchical-query-result-to-xml/ <br /><br />Cheers<br />Mattmnolanhttps://www.blogger.com/profile/03589368399513500774noreply@blogger.com