EXPERT RESPONSE
I recently attended a webcast on PL/SQL hosted by Steven Feuerstein.
In this webcast Mr. Feuerstein listed several points on what to do and
not to do. One of the things he listed on the not-to-do list is to
declare and initialize variables. Your case is a prime example of why not
to declare and initialize variables. I believe he suggested that you
assign values to variables just before you use them.
Personally, I am going to start using this rule of declaration and
initialization.
|
