Oracle Forms

hi

I have a query returning rows from multiple tables using a union clause.

while running the query at sqldeveloper returns all rows, but when using it in form returns only a few.

the query returns 54 rows

but when executed in forms, the timer breaks and does not display all rows.

the 10th row does not even gets completely populated.

in the form, I have created a non-db block (RENEW_TMP_BLK) to hold this data.

TIMER, in WNFI;

DECLARE
M_DUMMY1 VARCHAR2(1);
tm TIMER;

BEGIN

tm:=FIND_TIMER('RENEW');
IF NOT ID_NULL(tm) THEN
DELETE_TIMER(tm);
END IF;
tm:=CREATE_TIMER('RENEW', 1000, NO_REPEAT);
END;

WHEN-TIMER-EXPIRED

DECLARE

QUERY….

cursor c\_renew\_status is…..

 QUERY SET1

 UNION ALL

QUERY SET2

UNION ALL

QUERY SET3;

BEGIN

begin

 GO\_BLOCK('RENEW\_TMP\_BLK');  
CLEAR\_BLOCK(NO\_VALIDATE); first\_record;  
FOR idx IN c\_renew\_status LOOP  
  :rnw\_dc\_lse\_no                     := idx.DC\_LEASE\_NO;  
    :rnw\_prod\_code                     := idx.spec\_prod\_code;  
    :rnw\_spec\_part\_no             := idx.spec\_part\_no;  
    :rnw\_dc\_lse\_item\_code     := idx.DC\_LEASE\_ITEM\_CODE;  
    :rnw\_dc\_lse\_party\_code     := idx.DC\_LEASE\_PARTY\_CODE;   
    :rnw\_dc\_party\_acnt\_name := idx.ACNT\_NAME;  
    :rnw\_dc\_lse\_from\_period := idx.DC\_LEASE\_FROM\_PERIOD;  
    :rnw\_dc\_lse\_upto\_period := idx.DC\_LEASE\_UPTO\_PERIOD;  
    :rnw\_dc\_lse\_amount             := idx.DC\_LEASE\_AMOUNT;  
    :rnw\_dc\_lse\_discontinued\_yn := idx.DC\_LEASE\_DISCONTINUED\_YN;  
    next\_record;  

END LOOP;
first_record;
end ;

Please if some can help me on this issue. ai m using form6i with 10g.

Thanks