Home » Developer & Programmer » Forms » got problem handling error
got problem handling error [message #137271] Wed, 14 September 2005 03:54 Go to next message
prase_pk
Messages: 40
Registered: July 2005
Location: india
Member
I am using oracle 9i and forms 9i.I am trying to handle errors that occur in my form.

I am using commit_form to save the changes that I have made.
Now when there are any changes, the changes are getting applied to the database.Thats fine.And also it is throwing the message ORA-40400'Transaction complete...'X' number of records saved.'
I am trying to handle this message using lv_errcode and others.

I am handling all the other exceptions and errors this way to personalize them.All are working fine.But when I am applying this process to the above scenario,its not working....

can anybody explain why..... and how to solve this
Re: got problem handling error [message #137278 is a reply to message #137271] Wed, 14 September 2005 05:31 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I believe that's because it's not an error/exception. It's a message. Can you catch it in the ON-MESSAGE trigger?

MHE
Re: got problem handling error [message #137293 is a reply to message #137271] Wed, 14 September 2005 07:25 Go to previous messageGo to next message
prase_pk
Messages: 40
Registered: July 2005
Location: india
Member
thanx thats working fine
Re: got problem handling error [message #137296 is a reply to message #137293] Wed, 14 September 2005 07:35 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Another option would be to raise :SYSTEM.message_level.

Search for it on the board or look in Forms help.

MHE
Previous Topic: Menu Security & Security in Menu - merged
Next Topic: ...List Item problem.. want to add element dynamically..not working
Goto Forum:
  


Current Time: Fri Sep 20 00:45:53 CDT 2024