Returning Ref cursor between two oracle database

From: basant <basantshanker_at_hotmail.com>
Date: 8 May 2005 18:28:40 -0700
Message-ID: <1115602120.653094.128220@o13g2000cwo.googlegroups.com>

REF CURSOR question.

I have a package in X database with name PKG1 ... I have a Procedure which returns a REF CURSOR. Now I have to use this parameter as a input parameter in other procedure which is not a part of this package / database. i.e.

The procedure where I need to use this REF CURSOR belongs to a different database lets say 'Y' .... is it possible ? if yes can you please give a piece of code,
if not can you please give me some solution for this ?

I am using Oracle 9i.

Tried with creating private synonym but it did't work?

Thanks
Basant Received on Sun May 08 2005 - 20:28:40 CDT