I agree with Dirk, emphatically.
In PL/SQL, referencing variables in the proc_name.variable_name style
is overly verbose, hard to read, error prone, and basically disgusting
in general. I was never aware of any aD "style guide" saying to do it
that way, but if there was, that style guide was very misguided.
IMNSHO.
If there was a convenient concise namespace notation that meant the
same thing and did not constantly repeat the name of the
function or procedure everywhere (which you may well want to
change...), something like, this.variable_name
, say, then
that would be nice and maybe worth using. But there isn't, and
constantly referring to the
my_big_long_proc_name_foo.object_id
or whatever variable
is just plain obnoxious. Using p_update_date
or
q_update_date
or a similar convention like that is much
better. And the fact that this same convention also work in
PostgreSQL is a nice added bonus.