I need the convert Tsql trigger to Pl/Sqli could anyone help me?
CREATE TRIGGER Rep2_update ON
CA_VISIT_EVENT_ITEM
AFTER INSERT
AS
BEGIN
declare @event_item_id numeric(38,0),
@visit_id numeric(38,0)
declare
@agreement_number varchar(6),
@master_agreement_number varchar(6),
@company_number varchar(20)
select @event_item_id = EVENT_ITEM_ID, @visit_id = VISIT_ID from inserted
if @event_item_id = 289
begin
select @agreement_number = agreement_number from
CA_VISIT where VISIT_ID = @visit_id
select @master_agreement_number = master_agreement_number from AGREEMENTS
where AGREEMENT_NUMBER = @agreement_number
if @master_agreement_number is not null
begin
select @company_number = company_number from agreements
where agreement_number = @master_agreement_number
end
else
begin
select @company_number = company_number from agreements
where agreement_number = @agreement_number
end
update CA_VISIT_EVENT_ITEM
set CHAR_VALUE= @company_number
where VISIT_ID =@visit_id and EVENT_ITEM_ID = 289
Rather than trying to interpret T-SQL code, can you explain in plain language what it is you want your trigger to do after insert on CA_VISIT_EVENT_ITEM?