这是什么情况,PLS-00103:出现符号"|"在需要下列之一时：*&=-+;>atinist那里错了?createorreplaceprocedurefenye(tableNameinvarchar2,myPagesizeinnumber,pageNowinnumber,myRowsoutnumber,myPageCountoutnumber,

Question

这是什么情况,PLS-00103:出现符号 "|"在需要下列之一时：* & = - + ; < / > at in is t
那里错了?
create or replace procedure fenye
(tableName in varchar2,
myPagesize in number,
pageNow in number,
myRows out number,
myPageCount out number,
p_cursor out coursorpackage.c_cursor
) is
v_sql varchar2(1000);
v_begin number:=(pageNow-1)*myPagesize+1;
v_end number:=pageNow*myPagesize;
begin
v_sql:='select * from (select a1.*,rownum rn from (select * from ' ||tableName|| ') a1 where rownum='||v_begin;
open p_cursor for v_sql;
v_sql:='select count(*) from ' | |tableName;
execute immediate v_sql into myRows;
if mod(myRows,myPagesize)=0 then
myPagecount:=myRows/myPagesize;
else
myPagecount:=myRows/myPagesize+1;
end if;
close p_cursor;
end;

Answer 1

v_sql:='select count(*) from ' | |tableName;
这行里面看到吗,2个|中间多个空格