It dosen't stop..... What should I do now?

From: Shih-Chi Chiang <shihchic_at_isr.umd.edu>
Date: Thu, 24 Sep 1998 21:36:54 -0400
Message-ID: <360AF3B6.D77445E5@isr.umd.edu>

I try to run a simple PL/SQL program but it seems that it don't want to stop what I do to recorver it.
Can anyone tell me where is wrong in my code and how to stop it in this situation, thank you

CREATE TABLE T1(

        e INTEGER,
        f INTEGER

);

DELETE FROM T1;
INSERT INTO T1 VALUES(1, 3);
INSERT INTO T1 VALUES(2, 4); /* above is plain SQL; below is the PL/SQL statement */

DECLARE

        a NUMBER;
        b NUMBER;
BEGIN
        SELECT e,f INTO a,b FROM T1 WHERE e>1;
        INSERT INTO T1 VALUES(b,a);

END;
SQL> start test.sql

Table created.

0 rows deleted.

1 row created.

1 row created.
SQL> start test.sql

Table created.

0 rows deleted.

1 row created.

1 row created.

   9
 10
 11
 12
 13..... <---it doesn't stop, what should I do. Received on Thu Sep 24 1998 - 20:36:54 CDT