CREATE PROCEDURE add_human_info_tab(
param1 IN add_human_info_tab.id%TYPE,
param2 IN add_human_info_tab.name%TYPE,
param3 IN add_human_info_tab.area%TYPE,
param4 IN add_human_info_tab.profession%TYPE,
param5 IN add_human_info_tab.vocation%TYPE,
param6 IN add_human_info_tab.company%TYPE,
param7 IN add_human_info_tab.approach%TYPE,
param8 IN add_human_info_tab.email%TYPE,
param9 IN add_human_info_tab.phone%TYPE,
param10 IN add_human_info_tab.mobile%TYPE,
param11 IN add_human_info_tab.interest%TYPE,
param12 IN add_human_info_tab.memo%TYPE
)AS
BEGIN
DELETE FROM human_info_tab WHERE id=param1;
INSERT INTO human_info_tab(id,name,area,profession,vocation,company,approach,email,phone,mobile,interest,memo)
VALUES(param1,param2,param3,param4,param5,param6,param7,param8,param9,param10,param11,param12);
END;
第 2 行: 'param1' 附近有语法错误。
服务器: 消息 128,级别 15,状态 1,过程 add_human_info_tab,行 18
在此上下文中不允许使用 'param1'。此处只允许使用常量、表达式或变量。不允许使用列名。
服务器: 消息 170,级别 15,状态 1,过程 add_human_info_tab,行 2
这是怎么回事?