I am working in a Oracle 11g database migration to SQL Server 2012, I did the migration using SSMA v5.3 and all works fine. However, I did re-write code in some objects like triggers and stored procedures because the SSMA did a standard migration.
But my questions is about this: The Oracle Db have some packages that use global variables like this code:
CREATE OR REPLACE package OPS_TRACKING.pkg_trade_data as
-- packaged variable to be used by triggers not to execute during
-- archival and resoring process of the trade data
archive_restore_flag varchar2(1) := 'N';
procedure p_archive_trade_data( p_trade_id number );
In my case this global variable is called for some triggers like it:
CREATE OR REPLACE TRIGGER "OPS_TRACKING"."TG_TRADE_GROUP_AER_DI"
after insert or delete on ops_tracking.trade_group
for each row
declare
v_id number;
v_trade_id number;
begin
If pkg_trade_data.archive_restore_flag = 'N' Then
if inserting then
v_trade_id := :new.trade_id;
else
v_trade_id := :old.trade_id;
end if;
select id into v_id from ops_tracking.trade_summary
where trade_id = v_trade_id
for update nowait;
update ops_tracking.trade_summary
set transaction_seq=ops_tracking.seq_trade_summary_transaction.nextval
,last_update_timestamp_gmt = sysdate
where trade_id = v_trade_id;
End If; -- archive_restore_flag
end tg_trade_group_aer_di;
/
As you can see in this trigger the global variable
(pkg_trade_data.archive_restore_flag = 'N') is used for take a decision and based in their value the oracle trigger execute the action.
I would like to know which is the equivalent or which are my options to migrate this code to SQL 2012.
I appreciate your comments and advice's.
