It is often necessary to get a list of values from multiple rows. Generally, this is done using the cursor, which tends to make the task more complicated.
I tried to use ROWNUM pseudocolumn as:
SELECT GEN_CODE INTO :temp[i] FROM GEN_TABLE WHERE ROWNUM = i;
It works only for i=1!, because selecting only one row defaulted ROWNUM = 1 !. In order to select one row at a time, use nested select as shown here:
i=0DO i =i+1 SELECT GEN_CODE INTO :temp[i]FROM (SELECT GEN_CODE, ROWNUM rn FROM GEN_TABLE) WHERE rn =:i;LOOP UNTIL SQLCA.SQLCode = 100
Note: It is important to use aliase rn, because ROWNUM is getsoverriden by the outer select.
