Re: Trap no_data_found after execute_query in Oracle Forms
From: Mike Dwyer <dwyermj_at_co.larimer.co.us>
Date: Fri, 24 Mar 2000 08:03:12 -0700
Message-ID: <SwLC4.27$VM2.8502_at_wdc-read-01.qwest.net>
Date: Fri, 24 Mar 2000 08:03:12 -0700
Message-ID: <SwLC4.27$VM2.8502_at_wdc-read-01.qwest.net>
EXECUTE_QUERY;
IF :SYSTEM.BLOCK_STATUS = 'NEW' then
--nothing was retrieved
ELSIF :SYSTEM.BLOCK_STATUS = 'QUERY' then
--at least one row was retrieved
END IF;
<www_dba_at_my-deja.com> wrote in message news:8bf9bh$2c1$1_at_nnrp1.deja.com...
> 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.
Received on Fri Mar 24 2000 - 16:03:12 CET