怎么这个存储过程执行不了
创建表的语句CREATE TABLE customer_add_info_tab(
customer_id INTERGE PRIMARY KEY,
name varchar2(24) not null,
address varchar2(60) null,
code varchar2(24) null,
profession varchar2(24) null,
company varchar2(24) null,
email varchar2(24) null,
phone varchar2(24) null,
mobile varchar(24) null,
meet_time DATE null,
memo varchar2(1000) null);
存储过程语句:
SQL> create procedure add_customer_info_tab(
2 param1 in customer_info_tab.customer_id%type,
3 param2 in customer_info_tab.name%type,
4 param3 in customer_info_tab.address%type,
5 param4 in customer_info_tab.code%type,
6 param5 in customer_info_tab.profession%type,
7 param6 in customer_info_,
8 param7 in customer_info_tab.email%type,
9 param8 in customer_info_tab.phone%type,
10 param9 in customer_info_tab.mobile%type,
11 param10 in customer_info_tab.meet_time%type,
12 param11 in customer_info_tab.memo%type
13 )as
14 begin
15 delete from customer_info_tab where customer_id=param1;
16 insert into customer_info_tab(customer_id,name,address,code,profession,comp
any,email,phone,mobile,meet_time,memo)values(param1,param2,param3,param4,param5,
param6,param7,param8,param9,param10,param11);
17 end;
18 /
过程已创建。
如何执行这个存储过程呢??我执行了很多遍老是有错,哎,谁帮我执行一下啊,感激不尽