Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<m76kmu05130ft67qihus6aal8ot7s6lcbq_at_4ax.com>...
> On 26 Aug 2002 03:26:07 -0700, daud11_at_hotmail.com (Daud) wrote:
>
>
> The first procedure fetches each record individually to the local
> database. Each fetch, of whatever size (in this case 1 record)
> requires a sqlnet roundtrip
> Add the following to your code
> execute immediate 'alter session set event=''10046 trace name context
> forever, level 12''';
> and you will get a trace file which demonstrates this to you.
> The other procedure doesn't fetch anything to the local PC
>
Well, I dont get it. If the second procedure doesn't fetch anything to
the local database how can it does the insert? Where is it gonna get
the data from to do the insert?
rgds
Daud
Received on Mon Aug 26 2002 - 20:36:04 CDT
