404 Error - The requested URL /pls/apex/f was not found on this server
kleeJun 29 2007 — edited Jul 3 2007Running Application Express 3.0.0.00.20.
Database: Something in the 10g types.
I have a page where I have a SUBMIT_SAVE and a SUBMIT_CLEAR button.
In the processes in the after submit section, I have a conditional PL/SQL anonymous block that runs for each button. (I call a plsql procedure in a remote database. That procedure runs a bunch of api's that I can't call directly from ApEx.)
In the Branches, I have a process that just returns to the same page for both buttons.
At this time, the submit_clear works fine, but the submit_save gives the 404 error. If I refresh the browser, I get the successful message. I checked the results of the API calls, and the process does complete. (I can't create a user documentdefine the process to the end user to hit the refresh button when you get an error).
In my Apache error log, I find the following information:
From Apache Logs:
[Fri Jun 29 07:20:35 2007] [error] [client 10.100.22.20] [ecid: 72057688864625373,2] mod_plsql: /pls/apex/f HTTP-404 ORA-02041: client database did not begin a transaction
ORA-02063: preceding line from IASM_LINK
ORA-06512: at "FLOWS_030000.F", line 276
ORA-06512: at line 23
I have no clue how to troubleshoot this from here. An answer would be great, but I would really like to know how to solve this.
Thanks, Ken