Re: Dynamically execute PL/SQL statement
From: Kamal <kamal80_at_virgilio.it>
Date: 29 Oct 2004 08:40:56 -0700
Message-ID: <4e766a02.0410290740.3a358547_at_posting.google.com>
Date: 29 Oct 2004 08:40:56 -0700
Message-ID: <4e766a02.0410290740.3a358547_at_posting.google.com>
"Agoston Bejo" <gusz1_at_freemail.hu> wrote in message news:<clt7a9$ruj$1_at_news.caesar.elte.hu>...
> [...] because it runs the statement in the
> global context, not inside the context of the current function.
You could you use global variables in packages, but it is often a bad practice, prone to errors.
You can write:
execute immediate ('begin pkname.glob_var0 := something; end;');
Kamal Received on Fri Oct 29 2004 - 17:40:56 CEST