Home » Developer & Programmer » Forms » ON ERROR (IS NIK AROUND?)
ON ERROR (IS NIK AROUND?) [message #79338] Mon, 27 May 2002 09:38
Tyler
Messages: 123
Registered: January 2002
Senior Member
Hey,

I have this code

declare
msgnum number := MESSAGE_CODE;
msgtyp varchar2(3) := MESSAGE_TYPE;
begin
if msgtyp = 'ORA' and msgnum = 02292 then
message('Child Record Found, Can Not Delete');
end if;
end;

/*I have tried using it in a block level and form level trigger of on-error and also on-message and neither seem to display my message when the error arises. When I use on-error with the code, it simply doesn't display the error or even my message, just grabs it. The error being displayed is a FRM-(when-button-pressed error), but it's an ORA error, this is what I'm trying to catch*/
Previous Topic: Cursor
Next Topic: OLE2 and MS Word
Goto Forum:
  


Current Time: Thu May 23 05:12:27 CDT 2024