Re: local variable/column name conflict?

From: Bert Scalzo <bscalzo01_at_7-11.com>
Date: Wed, 19 May 1999 14:15:18 -0500
Message-ID: <7hv2dj$pnb$1_at_news.ses.cio.eds.com>

[Quoted] Never do this. PL/SQL order of precedence is column names first during parse resolution. SO this will always return all rows. This is a common PL/SQL mistake. Oracle education recommends in their training to prefix all var names with v_ Received on Wed May 19 1999 - 21:15:18 CEST

This message: [ Message body ]
Next message: James Thompson: "Syntax a Package with Procedures in Oracle. Any Ideas?"
Previous message: Chris Call: "Transparent gateway to DB2/AS400"
In reply to: Brenda A Graham: "local variable/column name conflict?"
Next in thread: Arjan van Bentem: "Re: local variable/column name conflict?"
Reply: Mungo Henning: "Re: local variable/column name conflict?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message