I use "EXECUTE" inside a stored procedure for just this purpose. This is not the same as PREPARE/EXECUTE, it lets you
sendan arbitrary string as SQL within the procedure. You have to write the query text on the fly in the procedure,
whichcan be a little messy with quoting and escaping.
Gaetano Mendola <mendola@bigfoot.com> wrote ..
> Hi all,
> do you know any clean workaround at ill-planned queries inside a stored
> procedure?