Re: declare variable in trigger

From: What's in a namespace <xml_at_ns.com>
Date: Sat, 23 Dec 2006 10:43:38 +0100
Message-ID: <458cfa3d$0$331$e4fe514c@news.xs4all.nl>

<harun.bolat_at_netsim.net> schreef in bericht news:1166858017.004548.269790_at_80g2000cwy.googlegroups.com...
> thanks for your reply.
>
> we use firebird database and try to migrate project to oracle. All our
> database object( trigger, stored procedure) we use variable name same
> as database field name and we have no problem. using variable same as
> field name, makes code more readable.
> to migrate oracle from firebird we try to write convert program that
> takes firebird sql and produce oracle sql code.
>
> In oracle stored procedure we can use variable name same as field name
> like procedure_name.variable_name syntax. This syntax why not exists it
> trigger? in firebird P/SQL syntax never change stored procedure or
> trigger.
>
> is there any solution or we have to change variable name?
>
>

Ok, this makes sense!
I'll check it out.

Shakespeare
(What's in a trigger?) Received on Sat Dec 23 2006 - 03:43:38 CST