RE: User defined context over a database link
Date: Tue, 22 Jan 2013 20:02:27 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD117CCEB87_at_G5W2734.americas.hpqcorp.net>
Write and local procedure that updates a context with the value of a passed in parameter then execute this procedure remotely passing the value to be stored into the context. So in the first instance your logic reads the value of the context and then calls the remote set context procedure passing the value to be set.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Schmitt
Sent: Tuesday, January 22, 2013 10:53 AM
To: oracle-l_at_freelists.org
Subject: User defined context over a database link
Hello,
Is anyone aware of a way that you can pass a context set in one instance and have it visible to a second instance when performing a select over a database link? For example, when a user runs a select over a public database link in instance A, making instance B aware of the context that was set in instance A. Hopefully I didn't mutilate that explanation too much.
In our situation, we are using VPD which is determined by the context in instance A that the user sets when they log in. The developers want that value to be visible to instance B if someone uses a database link to connect to it.
Outside of the design issues related to this, I didn't think it was possible and wanted to confirm with the list.
Thanks in advance.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 22 2013 - 21:02:27 CET