Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Juan David PalaciosMay 15 2012 — edited May 16 2012
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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 13 2012
Added on May 15 2012
1 comment
307 views