ALTER SESSION SET CURRENT_SCHEMA = "&1";

DELETE FROM SOLACE_TOPIC;

INSERT INTO SOLACE_TOPIC ST
  (ST.SOLACE_TOPIC_IN,
   ST.PRIORITY,
   ST.PROCESSING_NUMBER,
   ST.SOLACE_TOPIC_OUT)
VALUES
  ('stg/operations/account/assigned',
   1,
   1,
   'stg/operations/account/created/v1');
INSERT INTO SOLACE_TOPIC ST
  (ST.SOLACE_TOPIC_IN,
   ST.PRIORITY,
   ST.PROCESSING_NUMBER,
   ST.SOLACE_TOPIC_OUT)
VALUES
  ('stg/data/account/goldened',
   3, 
   2, 
   null);
INSERT INTO SOLACE_TOPIC ST
  (ST.SOLACE_TOPIC_IN,
   ST.PRIORITY,
   ST.PROCESSING_NUMBER,
   ST.SOLACE_TOPIC_OUT)
VALUES
  ('stg/operations/account/merging/notified', 
  2, 
  3, 
  'stg/operations/account/merging/ack/v1');
COMMIT;
/
exit;
