Re: remote database and cursor

Unless you have heavy logic in the body of your loop that can not be coded in SQL, then simply do:

insert into local_table select *

                        from
                                triton.mytable_at_PDCDB r
                        where
                                col1 = 'A';

If you do have some logic in the body, try coding it using SQL. SQL is almost always better than PL/SQL.

Even if your logic is so complex that you can not do it in a single SQL statement, I would consider pulling (as little as possible) data across in one statement into a local table, then doing that complex processing locally.

Kirill Received on Mon Sep 25 2006 - 19:39:13 CDT