Re: Trigger Question about the new and old

From: <pbolduc_at_my-deja.com>
Date: Thu, 09 Dec 1999 21:09:10 GMT
Message-ID: <82p5ph$jkp$1@nnrp1.deja.com>

In article <944716690.312063_at_news.chttl.com.tw>, "wls" <cuba_at_ms.chttl.com.tw> wrote:
>
> 1 Can I use the new as a parameter of a PL/SQL procedure???

No, but you can create a record of %ROWTYPE assign column by column and pass the record. (Oracle 7.3.4 you have to assign each column, 8?)

    rec table%ROWTYPE;
  BEGIN
    rec.ename := :new.ename;
    rec.salary := :new.salary;
    ...
    process_insert(rec);
  END;
> 2 Where is the description of new/old??
>

Oracle Server Concepts Manual

Phil Bolduc
North Vancouver, BC Canada

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 09 1999 - 15:09:10 CST