-- 创建存储过程createorreplaceprocedure pro_owners_add_2(
V_NAME varchar2,
V_ADDRESSID number,
V_HOUSENUMBER varchar2,
V_WATERMETER varchar2,
V_OWNERTYPEID number
-- 输出数据out
v_id out number
)isbegin-- 将序列id赋值给v_idselect seq_owners.nextval into v_id from DUAL;-- 向t_owners插入数据insertinto t_owners
values(v_id,V_NAME,V_ADDRESSID,V_HOUSENUMBER,V_WATERMETER,sysdate,V_OWNERTYPEID);-- 提交数据commit;end;-- 使用plsql调用函数向表中写入数据并输出declare
v_my_id number;begin
pro_owners_add_2('鲁班',1,'77','77',1,v_my_id);
DBMS_OUTPUT.PUT_LINE(v_my_id);end;
传出t_area表中的地址
createorreplaceprocedure fn_add_2(
v_name varchar2,
v_id out number
)isbeginselect seq_area.nextval into v_id from DUAL;insertinto t_area values(v_id,v_name);commit;end;declare
v_my_id number;begin
fn_add('河南');
DBMS_OUTPUT.PUT_LINE(v_my_id);end;