Date: Wed, 25 Feb 2009 12:39:34 -0800 (PST)
On Feb 23, 8:02 pm, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> Right, the local variable is visible - the function is not. The
> difference is there only for direct usage of both - when using EXECUTE
> IMMEDIATE you're lost in both cases.
Not really: you can still reference your PL/SQL variables with EXECUTE IMMEDIATE - but you need to explicitly bind them yourself (which PL/ SQL does for you automatically with native SQL):
x sys.dual.dummy%type := 'X';
execute immediate 'select dummy from sys.dual where dummy=:x'
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Wed Feb 25 2009 - 14:39:34 CST