Momentary absence of triggers

From: Tony Laaper <tonyla_at_gov.nb.ca>
Date: 1998/04/03
Message-ID: <3525243D.7138@gov.nb.ca>#1/1

Does anybody know what might have happened here? (The time delay between command and re-issue of command was
about one second. I was pretty terrified in that one second!) I'm absolutely sure no one else was even remotely near the user_triggers table. Running 7.3

Screen Capture Starts Here>>

Your Orders, Sir? select table_name, trigger_name, status   2 from user_triggers
  3 where table_name in ('ENCOUNTERS', 'CLINICAL_STAYS',
'DELIVERED_PROCEDURES',

  4 'DELIVERED_DIAGNOSIS', 'PROVIDER_INVOLVEMENTS',
'PROCEDURE_INVOLVEMENTS',

  5 'TRANSFERS', 'GROUPING_RESULTS')
  6 order by table_name;

no rows selected

Your Orders, Sir? /

TABLE_NAME                     TRIGGER_NAME                   STATUS
------------------------------ ------------------------------ --------
CLINICAL_STAYS                 CLINICAL_STAYS_EDITS           ENABLED
CLINICAL_STAYS                 CLN_STY_DELETE_TYPE_M          ENABLED
DELIVERED_DIAGNOSIS            DEL_DIAG_DELETE_TYPE_M         ENABLED
DELIVERED_DIAGNOSIS            VALIDATE_DX_CODE               ENABLED
DELIVERED_PROCEDURES           DEL_DELIV_PROC                 ENABLED
DELIVERED_PROCEDURES           VALIDATE_PROC_CODE             ENABLED
ENCOUNTERS                     ENCOUNTER_EDITS                ENABLED
GROUPING_RESULTS               GROUPING_RESULTS_EDITS         ENABLED
PROVIDER_INVOLVEMENTS          PROVIDER_INV_EDITS             ENABLED
PROVIDER_INVOLVEMENTS          PRV_INV_DELETE_TYPE_M          ENABLED
TRANSFERS                      DEL_TRANSFERS                  ENABLED
TRANSFERS                      TRANSFER_EDITS                 ENABLED

12 rows selected.

Your Orders, Sir?

<< Screen Capture Ends Here Received on Fri Apr 03 1998 - 00:00:00 CST