8.1.6 : nested tables

From: Yann CAUCHARD <yann.cauchard_at_spcconsultants.com>
Date: Mon, 29 Oct 2001 09:30:40 +0100
Message-ID: <9rj402$9in$1@news4.isdnet.net>

Hi,

I'm running 8.1.6 and I have nested tables of this kind :

.....

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 ?

Yann Received on Mon Oct 29 2001 - 02:30:40 CST