在一个存储过程中加了一句:execute procedure rjzy;却编译不了(原来的存储过程可编译可执行),出现下列提示信息:Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Dynamic SQL Error.
Input parameter mismatch for procedure RJZY.
successful execution of subsequent statements.
Dynamic SQL Error.
Input parameter mismatch for procedure RJZY.
改為這樣試試.
exec rjzy
exec procedure rjzy;
编译后出现提示:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 24, column 6.
procedure.如果改成这样:
execute procedure RJZY_SAVE (
TZHUYI date,
ZHUYI varchar(100),
K integer) ;
编译后出现提示:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 25, column 12.
date.
编译后出现提示:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 24, column 6.
procedure. 如果改成这样:
execute procedure RJZY(
TZHUYI date,
ZHUYI varchar(100),
K integer) ;
编译后出现提示:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 25, column 1…
[/Quote]