I have a problem:

I have a procedure A call procedure B and C, in B I use DB link to update 2 tables, in C I use DB link to insert records.

like this:
procedure A
... call Procedure B ...
......... in B: update table@dblink set field = field + 1
... call Procedure C ...
......... in C: insert into tableA@dblink select * from tableB ...

I can run through B without problem but always hang at first insert statement in C, no error message but only hang.

If I run the insert statement in SQLPlus, all scripts are ok.

Oracle environment:
procedure A run in 8.0.5 and dblink link to 8.1.6

Any one can help?

Thanks in advanced.

Wicky Hu