create or replace procedure cc(aa out cursor) is
begin
open cc for select * from xt_yh;
end ;Error: PLS-00201: 必须说明标识符 'CURSOR'
Line: 1
Text: create or replace procedure cc(aa out cursor) isError: PL/SQL: Compilation unit analysis terminated
Line: 0
Text: create or replace procedure cc(aa out cursor) is
请问该如何写
begin
open cc for select * from xt_yh;
end ;Error: PLS-00201: 必须说明标识符 'CURSOR'
Line: 1
Text: create or replace procedure cc(aa out cursor) isError: PL/SQL: Compilation unit analysis terminated
Line: 0
Text: create or replace procedure cc(aa out cursor) is
请问该如何写
create or replace package firstpages is type ResultData is ref cursor;
procedure firstproductss(
p_OutCursor out ResultData);
end firstpages;单独在procedures中建立不可以。