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 TOAD 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.IBM.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