var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Insert Through DB Link Hang the procedure
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.
... 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.
procedure A run in 8.0.5 and dblink link to 8.1.6
Any one can help?
Thanks in advanced.