Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Datalink error in Java CallableStatement

User_19BPUOct 14 2015 — edited Oct 14 2015

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 11 2015
Added on Oct 14 2015
1 comment
461 views