I am getting FRM-40505 unable to execute query in running an Oracle Form. I know which query is inducing the error message, but I see nothing wrong with it, and have successfully run it in SQLPlus. I would like to see the ORA error number and message, but when i install an On-Error trigger routine for this purpose I get ORA-00000 operation successful, which cannot be right. I would also like to look at the query as the Form has constructed it. What kind of trigger or other trace can I use?
