Web Development



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

By john.a.wills ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Reponse To Answer

by john.a.wills In reply to More info to your questio ...

Niether of those references leads anywhere useful.

Collapse -

Help/Display Error in Sungard's Banner INB,

by john.a.wills In reply to How do I find an Oracle e ...

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.

Related Discussions

Related Forums