编译过程提示错误什么 PLS-00103: 出现符号 "("在需要下列之一时 := . ) , @ % default
create or replace procedure pageset(pageno in number(3):=1 , pagesize in number(3):=1) is
pagecount number(3);
recordcount number(5);
begin
select count(*) into recordcount from student_info;
if mod(pagecount,pagesize)>0 then
pagecount := recordcount / pagesize +1;
else
pagecount := recordcount / pagesize;
end if;
if pageno <1 then
pageno := 1;
end if;
if pageno > pagecount then
pageno := pagecount;
end if;
select * from
(
select s.student_id,rownum as rown from student_info s
) where rown between pageno*pagesize-pagesize+1 and pageno*pagesize;
end pageset;
提示如下错误
PROCEDURE IGHACK.PAGESET 编译错误
错误:PLS-00103: 出现符号 "("在需要下列之一时:
:= . ) , @ % default
character
行:1
文本:create or replace procedure pageset(pageno in number(3):=1 , pagesize in number(3):=1)