Re: declare variable in trigger

"zauberberg" <jwberg_at_verizon.net> argued in news:1166808099.235449.67260_at_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
>

Please explain this. Why should one persist in naming a variable the same as a column, if there is no good reason for this? In this group we don't "mod down" replies . And if we would, yours would be a good candidate. But since I've never seen contributions by you in this group (unless this is a crossposted message), I guess you're new on the block, so you're forgiven. I could have suggested to prefix the variable with v_ (v_nsuid). Which is in fact no different then putting a : in front of it. Would that answer have satisfied you? Not me!
And YES, I have been an Oracle Developer for more than 10 years. And it seems Oracle Developers can be eloquent sometimes.

Shakespeare
(What's in a mod?) Received on Fri Dec 22 2006 - 18:35:40 CST