ORACLE存储过程一点注意

ORACLE存储过程的编写注意：

CREATE OR REPLACE PROCEDURE procedureName([parm[in|out|inout]type][..]) IS

 VAR1 NUMBER;

 VAR2 VAR1%TYPE;

 CURSOR CUR1 IS SELECT * FROM TBUSER;

 R_ROW CUR1%ROWTYPE;

BEGIN

   OPEN CUR1;

     LOOP                        //没有“;”结尾

       FETCH CUR1 INTO R_ROW;

       EXIT WHEN CUR1%NOTFOUND;

       ............................

       ......................

     END LOOP;

   CLOSE CUR1;

 

END;