Home » Developer & Programmer » Forms » ora-02292
ora-02292 [message #81073] Fri, 03 January 2003 01:34 Go to next message
Solve
Messages: 38
Registered: December 2002
Member
Mabe somebody could help me and tell, how to start to handle this error : FRM-40735 when-button-pressed trigger raised unhandled exception, ORA-02292?
It's about to tell the user that he can't delete record.
I would be very happy:)
Re: ora-02292 [message #81111 is a reply to message #81073] Wed, 08 January 2003 07:19 Go to previous messageGo to next message
monezz
Messages: 2
Registered: January 2003
Junior Member
create exception handler in when-button-pressed trigger.

trigger code example:

declare
..
e_no_delete exception;
pragma exception_init (e_no_delete,-02292);
begin
..
exception
when e_no_delete then
[[user friendly message]]
when others then
..
end;
Re: ora-02292 [message #81115 is a reply to message #81111] Thu, 09 January 2003 06:08 Go to previous message
Solve
Messages: 38
Registered: December 2002
Member
1000 thanks!! Going to try this code:)
Previous Topic: Resize Forms MDI Window
Next Topic: calculated items
Goto Forum:
  


Current Time: Fri Apr 19 11:26:03 CDT 2024