Oracle datalink error from Java

[Rithanya Laxmi]

Hi,

I am invoking a Stored Procedure from Java callable statement this procedure is using a data link to connect to a remote schema , when I invoke the procedure in SQL developer it is working fine. But through Java , I am getting the below error:-


ORA-04052: error occurred when looking up remote object PROD_TESTA.CUSTOMER@TESTA_LINK.CTS.COM


Below is the datalink created in the DB.

CREATE PUBLIC DATABASE LINK "TESTA_LINK"
CONNECT TO "PROD_TESTA" IDENTIFIED BY VALUES '055CBE575E7394622E642F389DD59F7F75973C2A781FB11B08'
USING 'localhost:1521/orcl';

Please let me know what is the issue here?


Thanks