Skip to Main Content
Forums

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

Chaitanya.S.S.K
you can use the dblinks in ur pl/sql cursor queries.

for ur reference:

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_56a.htm#SQLRF01205

and to use them for some advance concepts like authentication or replication, please search the documentation.
519688
well, since all pl/sql does is to pass the SQL statement to the database to be run, it's not a pl/sql issue. it's a SQL question. so it's the same as running the query in sqlplus (or toad or frog or whatever you use). the fact that it's embedded in pl/sql doesn't change anything, so: yes, it's possible, and no there aren't any do/don'ts (other than what would already apply to native SQL.
547947
Thnks Guys... :-)
585425
In My application encountering "ORA-01001: invalid cursor" error while calling the stored procedures using db link.

Can you please help me
585236
Verifies that these the procedure to which flames are compiled, that you have access permissions, that exist dblink, and that you are executing it with the permissions of the proprietor user of procedure.
1 - 5
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
779 views