Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    Triggers - checking via util menu not working

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    I am attempting to check on the status of triggers. When I run util a/17/6/4, I get dropped from the database. How can I determine what is going on with this? I need to determine if I have an Oracle problem (I did make some changes to the listener) or some other problem. How do I track this one down?

    Resolution:
    As shown by the following SQL, there are no Oracle triggers for any ABC01, ABC50, etc., tables:

    SQL-ABC50> select owner, trigger_name from all_triggers where owner like 'ABC%';

    no rows selected

    The USM tables have one trigger:

    SQL-ABC50> select owner, trigger_name from all_triggers where owner like 'USM%';
    **** Hit return to continue ****

    OWNER TRIGGER_NAME
    ------------------------------ ------------------------------
    USM50 Z1003_TRIGGER

    <end SQL>

    When you say you get dropped from the database, are you referring to the "Disconnected from Oracle Database" message? If so, that is normal, that's what you always see at the end of a util a/17/6.

    • Article last edited: 10/8/2013