oracle 存储过程

create table CXP_T_PROCEDURE
(
       PROID VARCHAR2(100),
       PRONAME VARCHAR2(100),
       PROPHONE VARCHAR2(100),
       PROADDRESS VARCHAR2(100)
)

insert into CXP_T_PROCEDURE (PROID, PRONAME, PROPHONE, PROADDRESS, ROWID)
values ('1', '张三', '18410081008', '北京', 'AABBNKAAMAAI80GAAA');

insert into CXP_T_PROCEDURE (PROID, PRONAME, PROPHONE, PROADDRESS, ROWID)
values ('2', '李四', '13410081008', '上海', 'AABBNKAAMAAI80GAAB');

insert into CXP_T_PROCEDURE (PROID, PRONAME, PROPHONE, PROADDRESS, ROWID)
values ('3', '王五', '15210011001', '深圳', 'AABBNKAAMAAI80GAAC');

insert into CXP_T_PROCEDURE (PROID, PRONAME, PROPHONE, PROADDRESS, ROWID)
values ('4', '赵柳', '15110081008', '杭州', 'AABBNKAAMAAI80GAAD');