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
