Oracle 存储过程报错 PLS-00103: Encountered the symbol

PLS-00103: Encountered the symbol “(” when expecting one of the following: := . ) , @ % default character The symbol “:=” was substituted for “(” to continue.

原因

在定义存储过程时参数指定了长度

-- 错误写法
procedure get_tip_data(rate_id in varchar2(40), cur_result out sys_refcursor);
-- 正确写法, 在 varchar2 后面不能限定字符串长度
procedure get_tip_data(rate_id in varchar2, cur_result out sys_refcursor);