Encountered the symbol “(“ when expecting one of the following:

  • Post author:
  • Post category:其他


[Error] PLS-00103 (1:22):pls-00103:Encountered the symbol “(” when expecting one of the following:

:=.),@% default character

The symbol “:=” was substituted for “(” to continue.

出现这个错误的原因是我在写procedure的有参时,参数里面是这么写的:

create or replace procedure test_wyh_pro (test_statement in varchar2(10))

正确的写法是参数中不需要定义数据的长度,去掉(10)即可。



版权声明:本文为QYHuiiQ原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。