• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle datalink error from Java

 
Rithanya Laxmi
Ranch Hand
Posts: 185
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic