c#关于分页存储过程遇到的错误问题

[a454315405]

ORA-06550: line 1, column 25:
PLS-00103: Encountered the symbol ":" when expecting one of the following:

( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively
ORA-06550: line 1, column 51:
PLS-00103: Encountered the symbol ":" when expecting one of the following:

( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql
ORA-06550: line 1, column 77:
PLS-00103: Encountered the symbol ":" when expecting one of the following:

( - + case mod new not null <an identifier>
<a double-quoted delimited-ident





请问这个是什么问题？？？很烦躁

[xdashewan]

可能是sql写法不符合Oracle的规范

[exception92]

储存过程语句不对，你现在数据库IDE里边 检测你的数据 看看有没有case 部分

[正怒月神]

直接在oracle执行存储过程，是什么结果

[a454315405]

引用 3 楼 hanjun0612 的回复:

直接在oracle执行存储过程，是什么结果

连接到数据库 orclhygldb。 进程已退出。 从数据库 orclhygldb 断开连接。

[a454315405]

引用 3 楼 hanjun0612 的回复:

直接在oracle执行存储过程，是什么结果

可以运行有分页结果