tag:blogger.com,1999:blog-20788401.post114461894912844479..comments2024-01-05T06:28:19.101+01:00Comments on daust_de :: Oracle XE / APEX: XE: Calling stored proceduresAnonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-20788401.post-22565925949852506012012-11-28T21:04:49.931+01:002012-11-28T21:04:49.931+01:00Thanks a lot for this tutorial. It helps me so muc...Thanks a lot for this tutorial. It helps me so much.<br />although the grant to anonymous didn't work, instead I made a grantee to APEX_PUBLIC_USER<br /><br />Raphael Nuneshttps://www.blogger.com/profile/06025701819506847226noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-74848710397758329702010-10-25T14:24:39.036+02:002010-10-25T14:24:39.036+02:00Thanks!! That worked a treat!!Thanks!! That worked a treat!!Unknownhttps://www.blogger.com/profile/14327169728477649815noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-72590414154833497732007-01-28T15:01:00.000+01:002007-01-28T15:01:00.000+01:00Hi Dietmar,
My goal is to implement an application...Hi Dietmar,<br />My goal is to implement an application specific REST-based WebService with mod_plsql. I'm using an OracleXE database to hold my business logic an data and expose it to the clients via this interface.<br />Before I tried to utilize the SOAP based .NET WebService functionality, but having a SOAP envelope around any request, having to have two WebServers, forcing my clients to install IIS etc. brught me to the point to look for this solution.<br />As it stands now, I'm slowly getting control over this environment and it seems to solve my requirements. I'm not using this in the environment of APEX, so interfacing with the APEX based procedures doesn't look too clean to me. This is why I'm looking for a separated approach.<br /><br />Best regards, JürgenAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-88482005286604196702007-01-28T09:18:00.000+01:002007-01-28T09:18:00.000+01:00Jürgen,
yes, wwv_flow_epg_include_modules.author...Jürgen, <br /><br />yes, wwv_flow_epg_include_modules.authorize is wrapped and for security reasons, I believe. The do some other checks and *also* call your local function wwv_flow_epg_include_mod_local to include *your* procedures.<br /><br />Yes, you can set another authorization function using DBMS_EPG, but I wouldn't see any reason to do so. <br /><br />Do you have any problems with this?<br /><br />What do you want to accomplish?<br /><br />Regards, <br />~Dietmar.Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-44901564529450185662007-01-28T07:31:00.000+01:002007-01-28T07:31:00.000+01:00Thanks very much for your example. I guess I'm abl...Thanks very much for your example. I guess I'm able to solve this now. Although: strange, but in my version of the database the wwv_flow_epg_include_modules.authorize is wrapped...<br />Am I right when saying that it should be possible to include an authorization method of my own by setting the request-validation-function-property to a value of my own choice?<br />At least I'm going to check that.<br /><br />Best regards, JürgenAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-68071516571937167982007-01-27T18:35:00.000+01:002007-01-27T18:35:00.000+01:00Hallo Jürgen,
as always, it depends a bit on wha...Hallo Jürgen, <br /><br />as always, it depends a bit on what you want to do. <br /><br />Yes, you would post a XML string like any other string. <br /><br />See this example: <br /><form id="form1" name="form1" method="post" action="http://127.0.0.1:8080/apex/hr.process_xml"><br /> XML<br /> <textarea name="p_xml" cols="50" rows="10"></textarea><br /> <input type="submit" value="Senden" /><br /></form><br /><br />and the stored function would be: <br />create or replace procedure process_xml(p_xml varchar2) is<br />begin<br /> htp.p(htf.escape_sc(p_xml));<br />end;<br />/<br /><br />grant execute on hr.process_xml to anonymous<br />/<br /><br />And finally you would have to allow the procedure HR.PROCESS_XML to be called like described above in the blog entry.<br /><br />As far as the 32K limitation goes, Carl Backstrom from the Apex team has built a workaround for it (if you are using it in an Apex application): <br />http://www.oracle.com/technology/products/database/application_express/packaged_apps/sample_code.html#LARGE<br /><br />I have created a modified version of it that runs on XE: <br />http://forums.oracle.com/forums/thread.jspa?messageID=1518418#1518418<br /><br />Regards, <br />~Dietmar.Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-31581951761895486292007-01-27T08:36:00.000+01:002007-01-27T08:36:00.000+01:00Hi Dietmar,
thanks for the useful instruction and ...Hi Dietmar,<br />thanks for the useful instruction and the refernce to the XE docs.<br />Wha I'm desperately looking for would be a hint on how to pass an XML document as a parameter. I'm aware of the 32K "feature" but this wouldn't be a problem for me. Yet, I'm quite sure that the XML files will extend the allowed URL size, so GET wouldn't be an option for me.<br />May I just POST an XML file as a parameter and will this then be mapped as a parameter?<br /><br />Thanks, JürgenAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-31458386098909271142006-12-04T23:29:00.000+01:002006-12-04T23:29:00.000+01:00Wolfgang,
if you really need to do this, you can...Wolfgang, <br /><br />if you really need to do this, you can create another package myhtp which calls the functions of sys.htp as a wrapper and allow that package to be called. <br /><br />Regards, <br />~Dietmar.Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-32644478724501289562006-12-04T23:01:00.000+01:002006-12-04T23:01:00.000+01:00Hallo Wolfgang,
I don't think this is possible, ...Hallo Wolfgang, <br /><br />I don't think this is possible, nor should it be. <br /><br />It seems like these system packages are excluded by default: <br />http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14190/confmods.htm#CIHIAHHG<br /><br />The parameter PlsqlExclusionList in the mod_plsql gateway is mapped to exclusion-list in DBMS_EPG:<br />http://dba-services.berkeley.edu/docs/oracle/manual-10gR2/appdev.102/b14258/d_epg.htm#BABFFDEH<br /><br /><br />Regards, <br />~Dietmar.Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-18903441117554618962006-12-04T17:09:00.000+01:002006-12-04T17:09:00.000+01:00hallo dietmar,
ich habe dies analog mit
sys.htp...hallo dietmar,<br /><br />ich habe dies analog mit <br /><br />sys.htp.print<br /><br />versucht.<br /><br />das tuts aber nicht!<br /><br />gruss wolfgangAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-54003826199014646042006-11-20T10:28:00.000+01:002006-11-20T10:28:00.000+01:00Thanks a lot, expecially for tips on SQL developer...Thanks a lot, expecially for tips on SQL developer!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-1161878030075139492006-10-26T17:53:00.000+02:002006-10-26T17:53:00.000+02:00Many thanks. We ported an app from an earlier XE v...Many thanks. We ported an app from an earlier XE version and had the same problem. Your instructions were very clear and fixed it for us too.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-1158757224175149772006-09-20T15:00:00.000+02:002006-09-20T15:00:00.000+02:00Hallo Dietmar,interessanter buggrüsse WolfgangHallo Dietmar,<BR/><BR/>interessanter bug<BR/><BR/>grüsse WolfgangAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-1152017920541337852006-07-04T14:58:00.000+02:002006-07-04T14:58:00.000+02:00Thanks! Saved my day tooThanks! Saved my day tooAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-1150883096640566912006-06-21T11:44:00.000+02:002006-06-21T11:44:00.000+02:00For me the same. Without this post i would not be ...For me the same. Without this post i would not be able to go on with my programming. thank you very muchAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-1145320081563545652006-04-18T02:28:00.000+02:002006-04-18T02:28:00.000+02:00Thanks! It solved my problem. Again thanks u very ...Thanks! It solved my problem. Again thanks u very much.Anonymousnoreply@blogger.com