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

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.



Mon, 12 Mar 2001 03:00:00 GMT
 It dosen't stop..... What should I do now?

On Thu, 24 Sep 1998 21:36:54 -0400, Shih-Chi Chiang

Quote:

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

/

A pl/sql block should be terminated with /



Tue, 13 Mar 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Query Analyzer dosen't load.

2. unattended installation dosen't work...

3. user already exists but it dosen't

4. Problem with SP that dosen't return a value to VB

5. HELP -- Progress Bar dosen't scroll

6. ADO dosen't return right value

7. The Manual Says......But it dosen't

8. TCL sh command dosen't work correctly

9. TCL sh command dosen't work correctly

10. cast dosen't work on pervasive.sql 7

11. ADO thinks DBMS is done, but DBMS ain't done

12. xp_sqltrace doesn't stop when stop command given


 
Powered by phpBB® Forum Software