[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
11/04/2009 at 07:23PM PST, ID: 24873384 | Points: 500
[x]
Attachment Details

How to inform ORACLE to use the object locally for DBLINK

Asked by chinsw in Oracle 10.x, PL / SQL

I developed a object function call 'decryptPAN' in Oracle and registered this object at my two databases; DB1 and DB2. My application need to access two DB1 and DB2 at the same time. So, i create a DBlink for this.
Let say, my application open database connection to DB1 and need to access Table1 from DB2 in order to get the card no in clear text from DB2. Then, I will issue the SQL statement like this : Select decryptPAN(card number) from Table1
However, i found out that Oracle will use the 'decryptPAN' from DB1 instead of DB2 to decrypt the card no when i issue the SQL command. This cause a performance issue to us when the volume is high. Is that any way to inform oracle to use the 'decryptPAN' object in the DB for the respective table. For eg: If the table is at DB1, then oracle should use  'decryptPAN' at DB1.
[+][-]11/04/09 08:01 PM, ID: 25746667

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/04/09 08:02 PM, ID: 25746673

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/04/09 08:05 PM, ID: 25746681

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/04/09 08:10 PM, ID: 25746710

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/05/09 01:18 AM, ID: 25747797

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 10:53 AM, ID: 25752619

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 12:56 PM, ID: 25753916

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20090824-EE-VQP-74 - Hierarchy / EE_QW_3_20080625