Maybe you also already got the 404 Not Found error message
The requested URL /pls/apex/wwv_flow.accept was not found on this server.
when you submit an Oracle APEX page, …
There are a lot of reasons why this error can occur. But the above error message doesn’t tell you a lot about the root cause of the problem. The real error message can be found on your Apache Web server in the Apache\Apache\logs\error_log.xxxxx file. There you will find and entry like
[Thu Apr 3 ...] mod_plsql: /pls/htmldb/wwv_flow.accept HTTP-404 wwv_flow.accept: SIGNATURE (parameter names) MISMATCH VARIABLES IN FORM NOT IN PROCEDURE: P_T02XXX NON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM:
Without the above information, you have no chance to find out what’s causing the 404 error. But the problem is, that most developers don’t have access to the application server.
You don’t have to!
Just put
<Location /pls/apex> ... PlsqlErrorStyle DebugStyle ...
into your dads.conf/marvel.conf and after restarting the Apache server you will get the error message directly in your browser.
For more details about PlsqlErrorStyle, have a look at the documentation.
Note: Only use this setting on developments systems, because on production systems a hacker might get more information as he should!
Credit for this tip goes to Dietmar Aust!
Pingback: Fehler 404 - die Lösung | Der Oracle APEX Experten Blog
Hi, Patrick! And what if I use apex with embedded pl/sql gateway. There is no Apache web server outside. In this case, where these log files with errors description could be placed? I have no idea though I need it indeed.
Hi Patrick,
I have the same problem like daneska.
My problem (look at http://www.htmldb.de/htmldb/read.php?4,2078) can not be identified.
Where can I find some errormessages in this case?
Kindly regards
Samson
Hi Samson and Daneska,
have a look at http://blog.oracleapex.at/fehler-404-die-losung/ which explains how you can do that for the Embedded PL/SQL gateway (EPG) as well.
You just have to execute
SQL>exec dbms_epg.set_dad_attribute(‘APEX’, ‘error-style’, ‘DebugStyle’);
Hope that helps
Patrick
Localized problem.
A nice colleague of us caring Company (DBA) has found in Internernet the statement.
Guilt is a bug in OracleXE that occurs when using Database link (Declaration Metalink 6798427.8).
Accordingly, I can not use the XE database as planned, because I wanted APEX run on XE-database, and everything connected via DB link with the environment.
Too bad the XE is certainly not maked “bug-free”.
Regards
Samson
Many thanks for this information. This helped us to locate faster and easily problems, which have nothing to do with the APEX applications itself but with the environment.
Good to see the error message rather than 404 error. I had been updating APEX with a hope that it will fix the problem but it appears that issue is inherited from XE Database that cannot be patched. Oracle does offer XE for free but unfortunately there is no support or patching and with License Agreement it is not clear whether the later patch that fixes this error on database will violate the XE license.
Hi Patrick,
Do you have any tips for checking the cause of the 404 error on a hosted instance?? I have been getting this error on a couple of my pages since the recent APEX 4.0, and it is causing my users a lot of grief (kids, by the way!!!). I am afraid I don’t know where to start investigating…
Many thanks!
Michelle
Hi Patrick, this really helped me out.
An unable to extend error caused the problem. Wouldn’t have thought of that so quickly!
Thanks again.
Peter