Re: remote database and cursor

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