Help, triggers in ProFORTRAN
Date: 1 Aug 94 13:19:02 EST
Message-ID: <1994Aug1.131902.21641_at_icf.hrb.com>
I am writing a precompiled application (ProFORTRAN) and I would like to create a trigger such that I will get some sort of asynchronous event inside my code any time another user modifies my database.
Is this possible? The ORACLE books only show triggers used in the most rudimentary sense, i.e. you can create a trigger that will cause a PL/SQL block to execute. But what I want to do when the trigger goes off must be done in FORTRAN, not SQL. Further, it looks like the embedded CREATE TRIGGER statement in my ProFORTRAN forces me to precompile the code with the SEMANTICS switch set, which means I must have access to all the tables referenced in the code when I compile it. That is totally impractical.
Is there a simpler way to make a database update simply give my program notification that it happened?
-- Max Magliaro MMM_at_ICF.HRB.COM Philipsburg, Pennsylvania "He may look like an idiot, and he may sound like an idiot, but don't let him fool you. He really is an idiot." --- Groucho MarxReceived on Mon Aug 01 1994 - 20:19:02 CEST