1 Reply Latest reply on May 16, 2012 5:41 PM by jflack

    How can I allow pl/sql procedure to be executed ??

    Juan David Palacios
      I'm receiving a 404 error when I try to execute a pl/sql procedure from the apex url:

      HTTP Status 404 - Not Found

      type Status report

      messageNot Found

      descriptionThe requested resource (Not Found) is not available.

      Oracle GlassFish Server 3.1.2


      The url I'm using is:


      http://localhost:8080/apex/efqm.test


      And the stored procedure is:

      CREATE OR REPLACE PROCEDURE EFQM.TEST AS
      BEGIN
      htp.p('Hello world this is a test!!!');
      END TEST;



      I've entered to the listener admin (http://localhost:8080/apex/listenerAdmin) and listed the allowed procedures (in the security tab) as follows:

      wwv_*,p,n,cust*,apex*,f,efqm.test*


      I'm using Oracle Apex Listener in Glassfish server 3.1.2.

      Edited by: Juan David Palacios on 15-may-2012 15:42