how to execute a procedure in remote database using DB Link.

 

Unable execute a procedure on another oracle database through DB Link.

Description:
I have two servers, A and B.  I two databases DB-A and DB-B.  Both are on Oracle10g and Linux environment. 

1. On Database DB-B:
Log on as DBB_SCHEMA on DB-B database.

Please note that  DBB_SCHEMA is the owner of a procedure and a table.

I have created a simple procedure as follows:

CREATE OR REPLACE PROCEDURE DBB_SCHEMA.test_mc2 (in_value in varchar2, out_value out varchar2)
AS

BEGIN

out_value := 'Hellow remote database';

insert into DBB_SCHEMA.t1 values ('row 1 inserted');
commit;
 
DBMS_OUTPUT.put_line (out_value);