Re: calling a procedure from a trigger in oracle 7.3

From: M.BALAKRISHNAN <m_balakrishnan_at_hotmail.com>
Date: Mon, 20 Apr 1998 08:54:47 -0700
Message-ID: <353B6FC7.7C5@hotmail.com>

Jonathan Gennick wrote:
>
> On Thu, 16 Apr 1998 14:40:10 -0500, John Franklyn
> <john.franklyn_at_workplacesystems.com> wrote:
>
> >Does anyone have an example of how to call a procedure from within a
> >trigger in Oracle 7.3? I have a trigger the calculates area totals. I
> >would like to pass the area total to a procedure, for update of another
> >table.

I rememeber reading somewhere in the amazing number of ORACLE books that are available that 'Stored procedures cannot be invoked from a DB trigger...'.. Perhaps it would be better to check with ORACLE itself!

M. Balakrishnan Received on Mon Apr 20 1998 - 10:54:47 CDT