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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Initial error in call to procedure is cached

Tomas AlbinssonSep 28 2011 — edited Oct 20 2011
Hi,

I'm running Apex 4.1.0.00.32, with Apex Listener 1.1.3.243.11.40 in WebLogic 10.3.3.0.
I've noticed that if I run a procedure (/apex/schema.procedure) and the first call is unsuccessful (because of an error in the procedure or lack of privilege), all later calls will also fail.

Example, create this procedure:

create or replace procedure bug as
begin
htp.p('Hello bug');
end;
/

Try to run it using the url http://<server>/apex/<schema>.bug
The web page will show just "Not Found". The listener error log will show
HTTP Status Code: 404 Requested url http://<server>/apex/<schema>.bug is not found.

The problem now is lack of grant. So, do a "grant execute on bug to apex_public_user;".
Refresh the web page but "Not Found" persists.

There are now two options:
- change the url to (for instance) http://<server>/apex/<schema>.Bug (ie change case)
- restart the whole weblogic server (stopping the Apex deployment is not possible)
As changing the case of the url is not practical if the application is generating links, a restart is the option left.

Is this "caching" of initial failure the expected behaviour or have I missed some configuration?
I have no caching enabled in the listener.


Kind regards

Tomas Albinsson
Stockholm, Sweden

Comments

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

Post Details

Locked on Nov 17 2011
Added on Sep 28 2011
8 comments
3,833 views