Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: EXECUTE IMMEDIATE + BULK COLLECT without knowing in advance the number of columns fetched ?

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

From: codadilupo <codadilupo_at_operamail.com>
Date: Fri, 14 Sep 2007 09:09:46 +0200
Message-ID: <46ea33b9$0$16020$5fc30a8@news.tiscali.it>


Mladen Gogala wrote:

> 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.

Sorry for the capital letters. My problem is that I'm not able to figure out the syntax for using execute immediate and bulk collect with a variable number of columns, so I cannot benchmark the two solutions.

-- 
CdL
Received on Fri Sep 14 2007 - 02:09:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US