Tuesday, August 31, 2010

Set OR Get apex item value

Procedure to set the apex item value

create or replace PROCEDURE PROC AS
BEGIN
    APEX_UTIL.set_session_state
    (
      p_name => 'P1_X',
      p_value => 'KARTIK');
END PROC1;

Here P1_X is the item name which is unique in APEX.

And call this procedure or also function in apex process.

Same way you can get the apex item value using get_session_state function:
 
APEX_UTIL.GET_SESSION_STATE (
    p_item    IN   VARCHAR2) 
    RETURN VARCHAR2;

Saturday, August 21, 2010

New feature in APEX Listener 1.0.1

There's a new feature in APEX listener 1.0.1

http://krisrice.blogspot.com/2010/08/getting-running-with-apex-listener-101.html

This feature is great for developer.

Wednesday, August 4, 2010

Installing APEX 4 on Windows Server 2003 64 bit edition with Oracle Database 11g

This tutorial article and it’s associated video will help guide you through the process of installing APEX version 4.0 in a Windows Server 2003 64 bit OS environment with Oracle Database 11g R2 installed.