Re: Pass a variable into procedure to use as column in select statement
Date: Fri, 04 Apr 2008 00:22:41 +0200
On Thu, 3 Apr 2008 12:11:43 -0700 (PDT), OutCast <Joe.r.rhea_at_jpmchase.com> wrote:
>Thanks, problem solved. I added the two new table and it worked
>perfectly, plus i'll store the knowledge of the "execute immediate"
>for when I really need it. It is amazing how doing it right always
>makes things so much easier.
Actually you still don't do it right. You have a denormalized table
design, and in order to get around this you are using dynamic sql,
which makes your app unscalable.
Hopefully there will never be someone who has to clean out the mess you left.
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Apr 03 2008 - 17:22:41 CDT