QUERY PROBLEM?

From: J. Yen <yhchou_at_comp.hkbu.edu.hk>
Date: Mon, 08 Jun 1998 19:37:37 +0800
Message-ID: <357BCCFE.2F331A3D_at_comp.hkbu.edu.hk>

[Quoted] I used the below SQL statement, but only last record selected. DECLARE
    CURSOR C IS

      SELECT A.SEQNO
            ,A.NAME
      FROM   NAME  A
      WHERE  A.DEPT = 'ACCT';

  BEGIN
    OPEN C;
    LOOP
    FETCH C INTO
               :SEQNO, :NAME;
    EXIT WHEN C%NOTFOUND;
    END LOOP;
    CLOSE C;   END;   Does anyone know the problem in this SQL statement? Thank you! Received on Mon Jun 08 1998 - 13:37:37 CEST