Re: declare variable in trigger

From: zauberberg <jwberg_at_verizon.net>
Date: 22 Dec 2006 09:21:39 -0800
Message-ID: <1166808099.235449.67260@48g2000cwx.googlegroups.com>

What's in a namespace wrote:
> <harun.bolat_at_netsim.net> schreef in bericht
> news:1166802666.166266.30290_at_48g2000cwx.googlegroups.com...
> > Hi all,
> >
> > firstly sorry my english,
> >
> > how can I use variable if variable name same as table's field name?
> >
> > CREATE OR REPLACE TRIGGER KULLANIC_BI BEFORE INSERT ON KULLANIC
> > FOR EACH ROW
> > DECLARE
> > NSUID INTEGER;
> > BEGIN
> > NSUID = 5;
> > SELECT MAX(K.NSUID) AS F_1
> > INTO NSUID
> > FROM KULLANIC K
> > WHERE K.NSUID = NSUID; /*this is my variable but oracle use this
> > variable as a table field.*/
> > END;
> >
> > is there any way use variable that name is same as field name?
> >
> >
> > in InterBase
> >
> > SELECT MAX(K.NSUID)
> > FROM KULLANIC K
> > WHERE K.NSUID = :NSUID /* ':' this syntax uses to determine variable
> > */
> > INTO :NSUID
> >
> > any help will be appreciated?
> >

> Use a different name for your variable, why not?

> Shakespeare
> (what's in a name?)

Please mod the above reply down, it is way too eloquent to be from an Oracle Developer Received on Fri Dec 22 2006 - 11:21:39 CST