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;