Re: EXECUTE IMMEDIATE Question

Nadeem Kafi wrote:
>
> Hi there,
>
> In my ongoing project, many of my procedures make heavy
> use of "Execute Immediate" PL/SQL command. Could somebody
> please comment on non-programming issues to consider
> when using this command? like performance e.g.
>
> TIA and Best Regards,
> Nadem Kafi.

As well an Johnathan's post, also see if a lot of DDL (create/alter/etc) is being done in the PL/SQL... If there is a lot, this often points to bad design, or people making non-Oracle assumptions about the Oracle database.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."