8.1.6 nested tables and triggers

From: Yann CAUCHARD <yann.cauchard_at_spcconsultants.com>
Date: Tue, 30 Oct 2001 09:12:08 +0100
Message-ID: <9rln9g$2est$1@news5.isdnet.net>

Hi,

I'm running 8.1.6 and I have a table with a nested table :

.....

HISTORY                         NOT NULL CHAR(1)
ACCESSID                                 VARCHAR2(20)
EVENT_PARAMS                             NAITT_EVENT_PARAMETERS

......

with

NAITT_EVENT_PARAMETERS TABLE OF NAIT_EVENT_PARAMETER

Name                            Null?    Type
------------------------------- -------- ----
SEQUENCE                                 NUMBER(3)
DISPLAY_PROMPT                           VARCHAR2(80)
BIND_PARAMETER                           VARCHAR2(80)

......
......

Is it possible to build a before Insert trigger on the nested table ? Is there a specific syntax ?

Thanks,

Yann Received on Tue Oct 30 2001 - 02:12:08 CST