Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

using DBLINK in PL/SQL SQL Query

547947May 16 2007 — edited Jun 28 2007
Hi

is it possible to use dblink in plsql cursor query.
are there any do's or dont's in this regard or any special things to take care of?

Basically what I need to do is access data from remote tables and put them in local tables after some proessing on data.

Any help !!

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 26 2007
Added on May 16 2007
5 comments
784 views