| 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*/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
