How to retrieve the number of rows returned by
From: <www_dba_at_my-deja.com>
Date: Sat, 25 Mar 2000 04:34:26 GMT
Message-ID: <8bhfkh$fem$1_at_nnrp1.deja.com>
Hi,
Date: Sat, 25 Mar 2000 04:34:26 GMT
Message-ID: <8bhfkh$fem$1_at_nnrp1.deja.com>
Hi,
Could anyone tell me how to retrieve the number of rows returned by EXECUTE_QUERY and assign it to a field.
I try COUNT_QUERY, GET_BLOCK_PROPERTY(QUERY_HITS) but the result is not satisfactory.
I try
LAST_RECORD;
:field_name := :SYSTEM.TRIGGER_RECORD;
FIRST_RECORD;
but I don't think it is good practice.
TIA.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Mar 25 2000 - 05:34:26 CET