Re: Help Please

Dear Zhangshi Yin

The Message you mention is the exception "too many rows". To fetch more than one row you have to use a Cursor to hold your query and you can use a Loop to repeatedly fetch from the cursor till the last row
is retrieved.
eg.
 Begin
   Declare

       Cursor X is
         select column1, column2 into :block1.field1, :block1.field2
         from table1
         where column1<100 ;


       ---

       ---

       begin
          open X ;
          loop
            fetch X into .... ........ ........ .......... ;
            Exit when X%NOTFOUND
             -----------------------------;
             -----------------------------;
          end loop ;
        end ;
      end ;