Manage HTTP Access in Application Express 3.0

Wow, Richard and I have been strugling with APEX 4 on XE for hours before we came across this port: http://www.emarcel.com/database/143-apexhttpccess It would have saved us hours.. thanks Marcin! <COPIED BLOG> After default installation of Oracle APEX 3.0, remote users are not allowed to access Database home page (APEXconsole) http://127.0.0.1:8080/apex http://localhost:8080/apex http://hostname.com:8080/apex (not allowed by default … Read more

Manage HTTP Access in Application Express 3.0

Wow, Richard and I have been strugling with APEX 4 on XE for hours before we came across this port: http://www.emarcel.com/database/143-apexhttpccess It would have saved us hours.. thanks Marcin! <COPIED BLOG> After default installation of Oracle APEX 3.0, remote users are not allowed to access Database home page (APEXconsole) http://127.0.0.1:8080/apex http://localhost:8080/apex http://hostname.com:8080/apex (not allowed by … Read more

APEX Popup LOV with more columns

Today I found a really neat plug-in to Oracle’s APEX. Have a look here: http://www.apex-plugin.com/oracle-apex-plugins/item-plugin/skillbuilders-super-lov_75.html All’s well, ut there is a downside to using this plug-in. Cascading Parent LOV’s are not supported yet. I hope they will soon. So I came up with an alternative that does use the native popup LOV. I altered the … Read more

Oracle DB on a notebook

If you want to install an Oracle database on a notebook, then it is essential that beforehand you install the MS Loopback adapter. This is a “virtual” network adapter. After installation assign it a fixed IP-addres (192.168.99.99 for example) and you’re ready to install the Oracle Listener and Database instances. You should not believe people … Read more