This content has been marked as final. Show 5 replies
This is a problem due to the libraries. Please refer Headstart Guide for more details. HSDUG65. This is one of the known problems and the solution is to
1. Check for uncompiled objects and compile the same.
2. Compile all the libraries.
3. Compile your Launch Form of the application again. Please re-attach all the libraries to avoid any reference problems before you generate an FMX.
Check file permissions and change them to 755 for all components If you have already tried the above.
Best Luck !
It is also happening if you have a trigger to call some values from a database table. So if you are doing operations (e.g. INSERT ) on a table connected to your form, do not forget to commit before running the form.
I have the same problem. Does anybodi know the sloution?
This bothers me few days, and im in big hurry, so I will realy appreciate your help.
Thank You very much!
I got this error message, too. But the message just a little difference:
FRM-40735 ON-INSERT trigger raised unhandled exception ORA-20002
And I find this message is sent by APP_EXCEPTION.RAISE_EXCEPTION; . So, I try to use message(sqlerrm); to print out the sql message. Thus I got the other message, and I figure it out. My suggestion is to use MESSAGE(SQLERRM) script. Maybe there's a little help for you.
that's right. FRM-40735 is a generic error message generated in case of form failure.
This may be as a result of failure while calling sub-programs in a form or any other problem.
For my case I had a call to a built in Package for which the user didnt have the privileges to execute that package.
So how did I find out?
WHEN OTHERS THEN
MESSAGE('SQLERRM: ' || SQLERRM);
exception handling does the trick. I got the real error that was causing the problem.
Error was: SQLERRM: xxx package does not exist. This made me think in the lines of either privileges or synonym problem. I found out that the user in the db doent have the execution privileges.
GRANT ALL ON xxxpackage TO xxxuser;
This is a nice forum. I love it and thanks to everyone.