SQL & PL/SQL :: Loading Data From Source To Target DB Using DBLink

Source and Target db version : 10.2.0.4.0
Source Os :Cent OS 5.4 and Target OS:Sun OS 5.10

We are loading data from source DB to target DB using dblink.Source db is having 15.4 crore records of number and varchar2 data types.

Using the logic as follows.
insert into table1 as select * from table1@dblinkname[/email];

DB link is working.If I give "select * from scott.REPORT@DBLINK[/email]" in target db alone i could retrieve records.

Actual query:

Create Or replace procedure test_abcd as
begin
Insert into test select *
from scott.REPORT@DBLINK[/email]
dbms_output.put_line('Hello world');
end;

When i give the above query in sqlplus ,it is hanging. When i see the wait events i could find

"Wait Event: SQL*Net more data from dblink"

How to get the above things working.? when checked with network team they says there is no issue in the network. Do we need to modify any database/network level parameter settings.there is no firewall between source and target db.