4 Replies Latest reply: Nov 12, 2013 8:59 AM by Luis RSS

    Validation function, PL/SQL is not being executed

    Luis
      Hello there,

      In one of my APEX listener setups I want to give access to only one application and block the rest. Basically I am following this nice post from Kris Rice: http://krisrice.blogspot.com.ar/2013/01/apex-listener-plsql-validations.html

      My problem is that my validation function is not being executed:

      - In ${config.dir}/apex/conf/apex.xml
      <entry key="security.requestValidationFunction">MY_SCHEMA.MY_PACKAGES.is_allowed(flow_id=>:P_FLOW_ID,page_id=>:P_FLOW_STEP_ID)</entry>
      - The function code:
      FUNCTION is_allowed(
          flow_id IN VARCHAR2,
          page_id IN VARCHAR2)
        RETURN BOOLEAN
      AS
      BEGIN
        insert into MY_SCHEMA.logs values (sysdate, flow_id);
        IF ( flow_id = 141 ) THEN
          RETURN true;
        END IF;
        RETURN false;
      END;
      But the logs table remains empty, snif...

      Any ideas?

      Thanks in advance,

      Luis