Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Calling a remote procedure using a dblink and ref cursor., Can't get it to work
SickOfOracle
post Jul 11 2008, 02:57 PM
Post #1


Advanced Member
***

Group: Members
Posts: 72
Joined: 19-October 04
From: DC
Member No.: 855



We are trying to call a remote procedure (A) through a dblink (cool.gif in a procedure © and return data using a ref cursor. Attached is the procedure, link and remote procedure. We get ora-02055, 02068, 03113, 06512.

(A)
CREATE OR REPLACE PROCEDURE "CDB"."EST_TEST" (o_cursor in out
types.v_cursor)
as
begin
execute immediate
'begin
open :0 for
select sysdate from dual;
end;' using o_cursor;
end;

(cool.gif
CREATE DATABASE LINK "ACES_CDBDEV" CONNECT TO "ACES"
IDENTIFIED BY "********"
USING 'CDBDEV

©
CREATE OR REPLACE PROCEDURE "ACES"."TEST_PROC" as
v_cursor types.v_cursor;
begin
open v_cursor;
cdb.est_test@aces_cdbdev(v_cursor);

end;

Is there a way to return a result set through a ref_cursor by calling a remore procedure?

Thanks in advance
JJ

Sorry the Smiley icon is the result of (cool.gif and the copyright icon is ©.

JJ
Go to the top of the page
 
+Quote Post
andrew kerber
post Jul 11 2008, 08:19 PM
Post #2


Advanced Member
***

Group: Banned
Posts: 489
Joined: 16-November 07
Member No.: 14,089



I dont know the exact cause of the problem, but you might try putting the stored procedure on the other side of the link, ie call the sp through the link.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 27th August 2014 - 10:13 PM