For a client I needed to develop an Apex page were some items were set when the user changed the value of a select list. Because of user-experience I did not want to do a post to the server. Instead…
Author Archive for Sergei Martens
Freelance Oracle Consultant - The Netherlands - Oracle DB, PL/SQL, Oracle Designer, Oracle Forms and Oracle APEX
Calling a REST webservice with pl/sql
by Sergei Martens • • 15 Comments

For a customer i needed to call a external REST webservice to update an external database with some specific information.
With the use of the utl_http package Oracle has made this very simple.
I tried to make the procedure i made, self-explaining.
Execute Page process with Ajax callback
by Sergei Martens • • 3 Comments
Sometimes you want to call a page-proces, but do need to make a compleet refresh of the page by making a request. In my case I made a simple master-detail screen with Tabs (Thank you Richard). In the tabs there…
Create collapsible list (alternative to apex tree)
by Sergei Martens • • 0 Comments
After some testing en struggling with the Apex-tree item I decided to look for an alternative for an expanding and collapsable html-list. Because of the integration with Jquery in apex, i obviously looked for an apex plug-in and found a…
Manage HTTP Access in Application Express 3.0
by Sergei Martens • • 0 Comments
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…
