Re: Dynamic "Orde by" parameter in Oracle Stored procedure
From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Wed, 18 Aug 2010 14:55:58 +0200
Message-ID: <i4gl9a$3iv$03$1_at_news.t-online.com>
Date: Wed, 18 Aug 2010 14:55:58 +0200
Message-ID: <i4gl9a$3iv$03$1_at_news.t-online.com>
Hi,
look at "execute immediate"
Build your statement into a varchar variable and then execute it
hth
Kay
Received on Wed Aug 18 2010 - 14:55:58 CEST