Re: Dynamically execute PL/SQL statement

"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 - 10:40:56 CDT