Re: EXECUTE IMMEDIATE + BULK COLLECT without knowing in advance the number of columns fetched ?

On Thu, 13 Sep 2007 16:46:13 +0200, codadilupo wrote:

> Is there a way to use EXECUTE IMMEDIATE together with BULK COLLECT for
> fetching rows from a query where the column list is built by the app at
> runtime or is DBMS_SQL the only way to go?
>
> Thank you. Kind regards,

First, capital letters in the title are considered offensive. Second, have you tried both versions and benchmarked it? How do you expect somebody to give you a sound advice without providing any additional information? I would go with what works faster for you. You can try it out, it's not illegal, unless you live in TX.

-- 
http://www.mladen-gogala.com