Approached by a provider of health wellness services, E-gineering was asked to help revive a dormant application into a viable technology offering. The client provides integration to a number of wellness services including health/risk assessment, healthy living programs, and other wellness related services. Relying on E-gineering to assist in technical development and infrastructure issues related to the resuscitating of the offering, they were then able to accelerate business plans. This included upgrading to the latest version of the .NET framework… [continue]
Getting the Status of an Oracle Trigger
Just a quick post about trying to determine the enabled/disabled status of an Oracle trigger. I found code snippets like this: Or like this: The first only gives you the triggers owned by the user session so if you are logged in as the admin, this won’t work for a trigger in a schema. The second one doesn’t work because the status of the object as Valid/Invalid. I figured if there is an all_objects table, there must be an all_triggers… [continue]