存储过程如下(存储过程返回的是一个游标):
create or replace procedure test (myid varchar2) return cursor as
declare
myinfo cursor;
begin
open myinfo for
SELECT sz_right.vch_rightid, sz_right.vch_rightname
FROM sz_right
where sz_right.vch_rightid > myid
return myinfo;
end;
出错信息:
Compilation errors for PROCEDURE SZCX.TEST
Error: PLS-00103: 出现符号 "RETURN"在需要下列之一时:
; is with authid as
cluster order using external deterministic parallel_enable
pipelined
Line: 1
Text: create or replace procedure test (myid varchar2) return cursor as