Question

Oracle Error ORA-06550 PLS-00103

存储过程如上图。断点执行OracleDataAdapter.Fill时报错如下。

ORA-06550: line 1, column 24: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 alternativelyORA-06550: line 1, column 39: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





Answer 1

names 前后，分别去掉一个单引号试试。。

追问

不行。无论是原来的还是按你说的去掉一个单引号，数据库 SQL执行没问题。用vs就有问题

Answer 2

你的语法有问题吧，再看一下存储过程的写法。。。