daud11_at_gmail.com wrote:
> DA Morgan wrote:
>> Daud wrote:
>>> DA Morgan wrote:
>>>> Daud wrote:
>>>>> I have the procedure below. It retrieves rows from a table at a remote
>>>>> database (over WAN link) and inserts into a local table. My question
>>>>> is, at Point A (where the cursor to remote table has been opened) is it
>>>>> possible for a glitch in the WAN to cause my procedure to fail?
>>>> Yes.
>>>>
>>>> But unless you have a paleolithic version of Oracle this is a poor
>>>> use of a cursor loop. Look to using array processing with BULK COLLECT
>>>> and FORALL.
>>>>
>>>> Demos under Array Processing in Morgan's Library at www.psoug.org
>>>> --
>>>> Daniel Morgan
>>>> University of Washington
>>>> Puget Sound Oracle Users Group
>>> How does it work with cursor? It doesn't pull all the records from the
>>> remote table in one go?
>>> I wouldn't use array processing ... no point when I am retrieving a few
>>> rows only most of the time.
>> And the value of writing less than optimal code is?
>>
>> If you learn to write the most efficient code all of the time ... you
>> will be writing the most efficient code all of the time. Assuming you
>> are not writing code for a single-user system the question you should
>> consider is what will happen when multiple users execute the code at
>> the same point-in-time.
>>
>> I'd suggest you rethink your objection as the difference between the
>> two is that it takes less code to do it more efficiently.
>> --
>> Daniel Morgan
>> University of Washington
>> Puget Sound Oracle Users Group
>
> You are concerned with array processing which is not an issue for me. I
> didn't ask about it because I already know about it. Tom Kyte's website
> has plenty of examples on it. If you look in my reply above, I asked
> about how cursor works over a remote db link - I wanted to know the
> details but you didn't answer it.
I did answer you but I will make my answer more explicit.
Use array processing! What you are contemplating will work and will be
very inefficient increasing the possibility that a WAN glitch will cause
an error.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Mon Sep 25 2006 - 11:32:49 CDT
