This content has been marked as final. Show 7 replies
gifted & smart? more like passionate and patient ;-)
My first question would be - how big is your report? The reason I ask this is because the application server will have a limit on the number of parameters per page submission, and that error get's thrown if you exceed that. Check your alert log for details.
I think the default is typically 2000 So if you have 200 rows with 10 fields each, you've just exceeded the limit. I think this still rings true with the way you've described submitting with nothing checked - it's been a while.
If not, forum still open for ideas!
It's an honor to hear from you, thank you so much for helping.
My report, currently, is only 3 records big, and each record has only 4 fields, not including the checkbox I added. In the future this report may expand to thousands, but not yet.
You mention an alert log, where might I find that? I haven't heard of such a thing so I don't know where to start to find it. Also, what might it tell me?
Thank you again very much for your help, I look forward to hearing from you.
Thank you for keeping with me and providing me with both help and explanation, I appreciate it.
Do I have to be a DBA in order to view the alert log? I only have access to tables and information through APEX, I'm just a developer, I don't know how to access the alert log through APEX and the information on the pages you provided does not appear to use APEX in order to display this information. If only a DBA can view the alert log, how would I ask it of them to view this information? That is, where do I tell them to look and what are they looking for?
Back to my original question and your last question about it, the URL I get when I get the "page not found" goes from being "https://esddev.wvu.edu/ncf/f?p=104:5:..." to "https://esddev.wvu.edu/wvu404error.html". It looks like this is a custom-created page intended to handle errors, however I have gotten errors in the past which did not lead to the "page not found" page. Would this be something set up by a DBA?
I wish there was a way to show you more of what I've done. Do you want me to include my PL/SQL? I have the PL/SQL which generates the checkboxes, and I have the PL/SQL which is supposed to either save the information into a new table or delete the record. Let me know if that might help you.
The alert log lives in the database server, which you may not have access to.
Depending on how active the database is, it's shouldn't be difficult to find information that relates to your task - if of course the problem can be found there. Your DBA should know where this file is located.
What version of APEX are you on? error handling has progressed recently. I asked about the URL because that may give hints as to what happened. The 404 page may be an application server setting, not sure.
PL/SQL may help...
Thank you so much for all of your help with this issue I've been having. The answer was actually given to me on another forum, and it's amazingly and frustratingly simple.
I did not have the checkboxes marked as "Standard Report column", I had them marked as "Simple Checkbox". Once I made the switch, the "page not found" stopped and my PL/SQL code for deleting or inserting the record actually worked.
So, everything was working all along, I just didn't have the column attribute for the checkboxes correct.
Thank you again for everything, have a great New Year.