场景:主系统注册一个用户,就回把账户信息同步到三个外接系统中。
思路:当主系统的user表添加数据时,执行触发器往另外三个系统中添加账户信息。
程序:
create or replace trigger busi_user_add_trig
after insert or update on busi_user
for each row
declare
user_space varchar(32);
org_id_out float;
company_id_out varchar(32);
/*定义游标,用于存储mystock_test中用户和菜单的数据*/
CURSOR c_vusermenu IS
select menu1_.menuid as menuid10_, menu1_.menuname as menuname10_, menu1_.pid as pid10_,
menu1_.menuurl as menuurl10_, menu1_.menutype as menutype10_, menu1_.ordernum as ordernum10_, menu1_.icon as icon10_
from mystock.rolemenu rolemenu0_, mystock.menu menu1_
where rolemenu0_.menuid=menu1_.menuid and rolemenu0_.roleid=1;
--定义一个接收每条数据的变量
c_vusermenu_data mystock.MENU%rowtype;
begin
for user_dict in (select id,user_space,sys_name from base_user_dict) loop
思路:当主系统的user表添加数据时,执行触发器往另外三个系统中添加账户信息。
程序:
create or replace trigger busi_user_add_trig
after insert or update on busi_user
for each row
declare
user_space varchar(32);
org_id_out float;
company_id_out varchar(32);
/*定义游标,用于存储mystock_test中用户和菜单的数据*/
CURSOR c_vusermenu IS
select menu1_.menuid as menuid10_, menu1_.menuname as menuname10_, menu1_.pid as pid10_,
menu1_.menuurl as menuurl10_, menu1_.menutype as menutype10_, menu1_.ordernum as ordernum10_, menu1_.icon as icon10_
from mystock.rolemenu rolemenu0_, mystock.menu menu1_
where rolemenu0_.menuid=menu1_.menuid and rolemenu0_.roleid=1;
--定义一个接收每条数据的变量
c_vusermenu_data mystock.MENU%rowtype;
begin
for user_dict in (select id,user_space,sys_name from base_user_dict) loop