17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure proc_ins_A(
in_seq_A IN A.SEQ%TYPE,
in_ZHANGMU_ID IN A.ZHANGMU_ID%TYPE,
in_ACCT_ITEM_ID IN A.ACCT_ITEM_ID%TYPE,
in_ACCT_ITEM_DESCRIPTION IN A.ACCT_ITEM_DESCRIPTION%TYPE,
in_RESTRICTION_GROUP_ID IN A.RESTRICTION_GROUP_ID%TYPE
) as
v_b_1 B.X_ACCT_ITEM_ID%TYPE;
v_b_2 B.X_JE_NAME%TYPE;
begin
insert into a (SEQ, ZHANGMU_ID, ACCT_ITEM_ID, ACCT_ITEM_DESCRIPTION, RESTRICTION_GROUP_ID)
values(in_seq_A,in_ZHANGMU_ID,in_ACCT_ITEM_ID,in_ACCT_ITEM_DESCRIPTION,in_RESTRICTION_GROUP_ID);
begin
select B.X_ACCT_ITEM_ID,B.X_JE_NAME into v_b_1,v_b_2 from b where b.L_ACCT_ITEM_ID = in_ACCT_ITEM_ID;
insert into a (SEQ, ZHANGMU_ID, ACCT_ITEM_ID, ACCT_ITEM_DESCRIPTION, RESTRICTION_GROUP_ID)
values(in_seq_A,in_ZHANGMU_ID,v_b_1,v_b_2,null);
exception when no_data_found then
null;
end;
exception when others then
raise;
end proc_ins_A;
/
--一个语句就行吧,确定你要写入的时机
INSERT INTO a
(SEQ, ZHANGMU_ID, ACCT_ITEM_ID, ACCT_ITEM_DESCRIPTION, RESTRICTION_GROUP_ID)
SELECT SEQ, ZHANGMU_ID, B.X_ACCT_ITEM_ID, B.X_JE_NAME, NULL
FROM a, b
WHERE a.ACCT_ITEM_ID = b.L_ACCT_ITEM_ID;