Disabling Apex items the right way

Sometimes you want to show data without the user being able to change it. The easiest way in Apex to use reports and read only items. There are use cases however for which this is not good enough.For example when you want to change from read only to editable item dynamically or vv. Or if … Read more

making https (webservice) requests from PL/SQL without a wallet

While developing the application for my kscope15 presentation I discovered that my Oracle XE database is unable to handle the certificate for Linked-in. This has to do with the algorithm used to sign the Linked-in certificate. Oracle XE 11 has a bug that prevents it from handling the certificate correctly. The solution lies in creating … Read more

Fully freeware APEX environment VI: Oracle HTTP server (installation)

This is post 6 in my series about a fully freeware APEX installation: Information has been taken from The Oracle Install guidelines http://eelzinga.wordpress.com/2009/07/04/oracle-fusion-middleware-11g-ofm11g-on-centos-5/ Shut down EPG The EPG is still running. To shut it down, open SQL*plus:conn conn system execute dbms_xdb.sethttpport(0); exit Prerequisits Make sure your system has enough memory (2 Gigs or more) We … Read more

Fully freeware APEX environment IV: GlassFish Installation

This is part 3 of my series on a fully freeware APEX environment on CentOS: This post consists of 3 parts: Install Java Glassfish preparations Install GlassFish Configure Glassfish (part 3a) Information has been taken from: http://www.scribd.com/doc/19252518/StepbyStep-Install-Guide-Sun-GlassFish-Enterprise-Server-v3-on-Linux (glassfish part) http://bhapca.blogspot.com/2009/05/how-to-install-glassfish-on-centos-and.html (java part) Here we go… Install Java CentOS allready comes with java pre-installed: /usr/bin/java -> … Read more

Fully freeware APEX environment V: Configure GlassFish

In this post we’ll configure the GlassFish 3 server that we installed in the previous post. Information has been aggregated from different blogs: http://www.davidghedini.com/pg/entry/install_glassfish_3_1_on http://bhapca.blogspot.com/2009/05/how-to-install-glassfish-on-centos-and.html The APEX Listener Installation guide (pdf) Apex & Apex listener download Apex and the listener should be downloaded now. Now we start the admin console and mkdir -p $ORACLE_BASE/product/1.1.2/apxlistener mkdir … Read more

Fully freeware APEX environment III: The APEX listener

This is post 3 in my series about a fully freeware CentOS Apex environment Configure the APEX Listener Your listener is deployed, but not yet configured. Go to http://localhost:8080/apex/listenerConfigure We must set parameters in three tabs: Connection Username: apex_public_user Password: the password as set earlier for this user Connection Type: Basic Hostname: localhost Port: 1521 … Read more