Re: Trap no_data_found after execute_query in Oracle Forms

In article <8bf9bh$2c1$1_at_nnrp1.deja.com>, www_dba_at_my-deja.com says...
>
>Hi,
>
>Could anyone tell me how can I trap no_data_found after execute_query
>in Oracle Forms.
>I tried exception no_data_found but failed.
>
>I am doing something like:
>
> go_block ('Block1');
> execute_query;
> enter;
> if form_success then
> go_block ('Block2');
> end if;
> if no record found return to Block1.
>
>TIA.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Hello
You have to use the following construct (exception handler) :

begin
  go_block ('Block1');
  execute_query;
  enter;
  if form_success then
    go_block ('Block2');
  end if;
exception
  when No_Data_Found then go_block('Block1'); end;

Pierre Received on Mon Mar 27 2000 - 10:37:01 CEST