Re: Trigger Question about the new and old

From: <moerkd_at_my-deja.com>
Date: Fri, 10 Dec 1999 21:02:35 GMT
Message-ID: <82rpp8$g3v$1@nnrp1.deja.com>

In article <944717089.372908_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???
> 2 Where is the description View of new/old??
>
>

Hello,

new and old are specific to triggers so if you call a procedure from a trigger then use parameters to call the procedure For examle :

procedure test (p_1 in varchar2,p_2 in varchar2)

then call the procedure from your trigger with test(:xxx.new,yyy.old);

hope that helps

Detlev

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