CREATE OR REPLACE PROCEDURE TEST_PRO(ID out varchar,TITLE out varchar) AS CURSOR FORUMCURSOR IS SELECT ID,TITLE FROM para; BEGIN OPEN FORUMCURSOR; LOOP FETCH FORUMCURSOR INTO ID,TITLE; EXIT WHEN FORUMCURSOR%NOTFOUND; END LOOP; CLOSE FORUMCURSOR; END;把WHERE改成WHEN
看样子你想用OUT参数在存储过程中返回多个值。 可以这样写: ...... open FORUMCURSOR; fetch FORUMCURSOR into ...; while FORUMCURSOR%found loop ...... fetch FORUMCURSOR into ...; end loop; close FORUMCURSOR; ......
PROCEDURE TEST_PRO(ID out varchar,TITLE out varchar)
AS
CURSOR FORUMCURSOR IS
SELECT ID,TITLE FROM para;
BEGIN
OPEN FORUMCURSOR;
LOOP
FETCH FORUMCURSOR INTO ID,TITLE;
EXIT WHEN FORUMCURSOR%NOTFOUND;
END LOOP;
CLOSE FORUMCURSOR;
END;把WHERE改成WHEN
可以这样写:
......
open FORUMCURSOR;
fetch FORUMCURSOR into ...;
while FORUMCURSOR%found loop
......
fetch FORUMCURSOR into ...;
end loop;
close FORUMCURSOR;
......