Re: Writing database triggers

From: <joelga_at_rossinc.com>
Date: 1997/04/29
Message-ID: <862340540.11285@dejanews.com>#1/1

In article <335B7E3F.666_at_access.net.au>,   Peter Yates <PeterYates_at_access.net.au> wrote:
>
>
> Hi
>
> Does anyone know how to find errors in a trigger when compiling it?
> SHOW ERRORS doesn't always do the trick.
>
> Thanks
> Peter

Besides the SHOW ERRORS TRIGGER triggername, these are some interesting tables:

TRIGGER$        Source code
IDL$ tables     P-code and debug code
DEPENDENCY$     Dependencies
OBJ$            Trigger object status
ERROR$          Errors generated during compile

DBA_OBJECT_SIZE Sizes of pieces of trigger

Triggers were anonymous PL/SQL blocks prior to 7.3, now they are a new form of executable object. More space is used in the System tablespace.

Reference: Advanced Oracle Tuning and Administration, Aronoff etal.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Tue Apr 29 1997 - 00:00:00 CDT