tag:blogger.com,1999:blog-1271763227002553835.post5198397269277119339..comments2024-03-26T08:42:34.744+01:00Comments on Notes on Oracle: Should you expose a Stored Procedure via XMLType?Alex Nuijtenhttp://www.blogger.com/profile/06345615264010120428noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-1271763227002553835.post-61973372925704754232015-07-23T09:08:34.410+02:002015-07-23T09:08:34.410+02:00True. Downside of this flexibility is that you nee...True. Downside of this flexibility is that you need to write a lot more code by hand instead of drag-and-drop. The complete transformation needs to be hand-written. Of course the choice is yours :)Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-67773606074590663252015-07-22T21:16:23.549+02:002015-07-22T21:16:23.549+02:00i meant that you can open database package/functio...i meant that you can open database package/function/procedure and analyze possible xml structure<br /><br />also<br />imho interesting point is extensibility<br />if you have type then you have hard coded structure and some modification ( add element in type ) lead to regenerate code of dbadapter ( in particular xsd of dbadapter)<br />but if you have returned xml ( may be clob ) then you can modify ( as example add element ) xml as needed without regenerating dbadapter<br />it's like parseXml(returnedClobAfterInvokeDBAdapter)/someElement<br /><br />looks like i prefer flexibility instead of visibility<br /><br />thanks for the post and time for rethink of reterned typeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-28713160916714592262015-07-21T21:04:13.453+02:002015-07-21T21:04:13.453+02:00Yes, all about visibility.Not sure what you mean b...Yes, all about visibility.Not sure what you mean by "investigate xml structure by db code" Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-87095862375419996342015-07-21T17:32:28.057+02:002015-07-21T17:32:28.057+02:00so it's all about visibility ? ( btw you can i...so it's all about visibility ? ( btw you can investigate xml structure by db code )<br />but that about performance ? did you check it ?<br />imho it's interesting comparisonAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-88187310667735157402015-07-21T09:06:22.967+02:002015-07-21T09:06:22.967+02:00Of course that's possible, but when you're...Of course that's possible, but when you're working with a Mediator (like in the examples above) it is easier to create a mapping when the full structure is visible.<br />If you have to work in the mapper and only this (3.bp.blogspot.com/_tdqazgf19_s/TRNFDXN8bdI/AAAAAAAAA7E/3o4Wb5UsLU0/s1600/XmlTypeMapping.png) is visible, you have no idea what the structure looks like.<br />Then you would have to write a lot of XSLT expressions by hand, instead of using Drag-and-DropAlex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-20166924242285251092015-07-20T20:47:52.044+02:002015-07-20T20:47:52.044+02:00i can't feel situations where i must prefer ty...i can't feel situations where i must prefer type instead of xml =/<br />why you can not cast "any" to xml and parse as need ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-39825993142942498402011-11-04T18:50:12.375+01:002011-11-04T18:50:12.375+01:00I agree that use of XML type for exposing your sto...I agree that use of XML type for exposing your stored procedure to outside world is always depend upon situation. In some situation it works well while in other it didn't. You explained this concept very well and make the task of developers easy.sap erp systemhttp://www.panayainc.com/noreply@blogger.com