error trapping in FORMS 5

From: wozi <wozi_at_dhc.net>
Date: Sun, 17 Oct 1999 12:55:03 -0700
Message-ID: <7BE44547B0C08A8B.9BEF5AD575570426.D7FA1A449D231D1C_at_lp.airnews.net>



When I issue execute_query using set_block_propert's default_where, I get FRM:40350 when no is found. However, when there is data, it works. I want to trap 40350 and replace it with my alert message.

on-error trigger at theblock level



declare
  al_button number;
  v_errr number := ERROR_CODE;
begin
  if v_error = 40350 THEN
    al_button = show_alert('myalert');
   raise form_trigger_failure;
 end if;
end;

This does not work!

Any help would be appreciated Received on Sun Oct 17 1999 - 21:55:03 CEST

Original text of this message