一个简单的oracle问题

Question

show error命令查看错误信息

Answer 1

insert info customer_info_tab
少了个into ，应该是insert into ...
还有每个delete 及insert 后都要跟个commit;

Answer 2

insert info customer_info_tab  -->into

Answer 3

insert info customer_info_tab 这个错误是我不小心打错了。毛病不是出在这个地方。到底怎么了好难过！！！！！

Answer 4

create table customer_info_tab(
customer_id                   number(3),
customer_name                 varchar2(20),
customer_phone                number(7))create or replace procedure add_customer_info_tab(
param1 in customer_info_tab.customer_id%type,
param2 in customer_info_tab.customer_name%type,
param3 in customer_info_tab.customer_phone%type)
as
begin 
delete from customer_info_tab where customer_id =param1;
insert into  customer_info_tab
(customer_id,customer_name,customer_phone)
values(param1,param2,param3);
end;没问题啊你把报错信息发上来啊