Re: remote database and cursor

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. Received on Sun Sep 24 2006 - 21:58:22 CDT