tag:blogger.com,1999:blog-12214002.post8277087739353145934..comments2024-03-09T06:56:57.099-05:00Comments on Let's Wreck This Together...with Oracle Application Express!: Minimum database version for Application Express 4.0Joel R. Kallmanhttp://www.blogger.com/profile/01915290758512999160noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-12214002.post-1905769393463019222009-10-30T19:26:26.283-04:002009-10-30T19:26:26.283-04:00Thank you for the Oracle XE and APEX 4.0 related i...Thank you for the Oracle XE and APEX 4.0 related information, Joel. I found the answer to my question (which I sent to David Peake, but haven't heard back) found it on your blog. Thanx again and best regards.<br />Zafer, Monterey-CA.Unknownhttps://www.blogger.com/profile/14317557461343174236noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-79740264448843816772009-09-11T13:52:06.444-04:002009-09-11T13:52:06.444-04:00APEX 4.0... I'll wait to play it ;)APEX 4.0... I'll wait to play it ;)Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-13399878230558934462009-09-11T11:05:30.443-04:002009-09-11T11:05:30.443-04:00@Chris - the biggest, if not the only, reason to r...@Chris - the biggest, if not the only, reason to require 10.2.0.3 versus 10.2.0.1 is the inclusion of the useLogonRoles parameter in the dynamic SQL parsing package SYS.DBMS_SYS_SQL. Without this ability to respect logon roles when parsing SQL, DBMS_SYS_SQL required direct object privileges instead of privileges granted through a role.<br /><br />In Application Express 3.2.1, you can access an object in SQL Commands where you have been granted privileges through a role. However, within a developed APEX application, you (really, your parsing database user) would need direct object privileges - the intent was to mirror functionality of PL/SQL. However, it is our intent in 4.0 to even remove this limitation from developed applications.<br /><br />This parameter useLogonRoles was added to DBMS_SYS_SQL in support of XE. XE is listed as database version 10.2.0.1. However, useLogonRoles didn't make it into the mainstream database releases until 10.2.0.3. That's why I always say that XE is really 10.2.0.1+.Joel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-41780971357548951822009-09-11T02:48:18.871-04:002009-09-11T02:48:18.871-04:00Hi!
First of all, I think it's understandable...Hi!<br /><br />First of all, I think it's understandable (and in fact a very good idea) to drop 9i support and use features of 10g in the new APEX version, e.g. regular expressions. Adoption of 4.0 might be more difficult than desired if it requires a newly patched 10.2, however. At least many of our customers have unpatched 10.1 and 10.2 databases for their back office systems. Rolling out an APEX 4.0 based product will be more difficult (and expensive) then simply dialing in, "cvs update" and running a few SQL scripts, as we expected. Well, it's a thing we'll have to deal with, then. Thanks for the warning, it's yet another reason to get them to the newest patchsets.<br /><br />Just out of technical interest: Can you explain which issues you had with 10.2.0.1? Out of memory I can't remember changes in PL/SQL, so there might be problems with (or lacking features of) pre-installed packages that could be of interest to a bigger audience.Chrishttps://www.blogger.com/profile/00349422981782291908noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-51960075858334481722009-09-10T17:59:04.590-04:002009-09-10T17:59:04.590-04:00Oracle XE rules!
:-DOracle XE rules!<br /><br />:-DByte64https://www.blogger.com/profile/15629209362377395020noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-80588513195827175582009-09-10T16:49:11.331-04:002009-09-10T16:49:11.331-04:00@thierry - APEX 4.0 isn't available. I'm ...@thierry - APEX 4.0 isn't available. I'm not sure how you can install APEX 4.0 on 11 db.Joel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-18167578301664236262009-09-10T16:37:12.948-04:002009-09-10T16:37:12.948-04:00Have an issue installing it on the 11 db too. Can ...Have an issue installing it on the 11 db too. Can you send me via email the latest build, so i can retest the install? thanks :)thierryhttps://www.blogger.com/profile/11767682220351777439noreply@blogger.com