Re: Get the table name in a trigger

From: Michael Krolewski <vandra_at_u.washington.edu>
Date: 1998/08/25
Message-ID: <35E3AA65.6A25DE4C_at_u.washington.edu>#1/1


[Quoted] I believe the question is answered with dynamic SQL.

[Quoted] The dynamic SQL package (dbms_sql ) allows for the construction of any query at runtime. Assuming that rest of the information / data is consistent one
[Quoted] can transfer in the table name at runtime, construct the sql statement, parse and
execute it.

[Quoted] This is all in the programming manual.

Mike Krolewski

Matthew, MacFarland wrote:

> Hello everyone,
>
> Is there a way to get the name of the table that a trigger is defined on
> from within the trigger code at run time?
>
> Each of the triggers in the application I am working on calls a procedure
> which takes the table name as a parameter and I am trying to find a way to
> avoid hard coding the table names in all the triggers.
>
> Thanks,
>
> Matthew MacFarland
> Dril-Quip, Inc.
Received on Tue Aug 25 1998 - 00:00:00 CEST

Original text of this message