Question Locked

How do I find an Oracle error when I get FRM-40505 in an Oracle Form?

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

4 replies

by john.a.wills

and possibly in other Oracle Forms environments, shows the query as constructed and the ORA error message. This solves the problem I set, although after some investigation I may be back with a deeper question.

This discussion is closed to new replies.