Create procedure proc_XXX_data as
The begin
Insert into DBYL (a, b, c)
Select 1, 2, 3 from TABLE111;
commit;
End proc_snap_data;


DBYL is synonymous with a list a DBLINK aaa

An insert into DBYL alone (a, b, c)
Select 1, 2, 3 from TABLE111; No problem

But execute the stored procedure error: ORA - 04052: in finding an error occurred when the remote object SSS @ aaa
ORA - 00604: recursive SQL error level 1
ORA - 12170: TNS: connection timeout

CodePudding user response:

Stored procedure is not under the current user, synonymous with stored procedure corresponding to estimate different from your local build

CodePudding user response:

Empowerment give it a try!

CodePudding user response:

It may be because the database version caused by inconsistent to patch? What is your specific version of the 2 side database?

CodePudding user response:

1. With the user. Tablename @ dblink try this way
2. Check the permissions