ORA-02064: distributed operation not supported using dblink
Hi
I'm using sql developer to test this
I have a package with few procedures in it on the one of the database
when these procedures are called directly
my_support_api.create_user('Archtestdm','USERS_T_S_01','TEMP','welcome123', ret_num, ret_msg);
it works without any error
but when I call from another database via link
declare
ret_num number;
ret_msg varchar2(400);
begin
my_support_api.create_user@my_link('Archtestdm','USERS_T_S_01','TEMP','welcome123', ret_num, ret_msg);
dbms_oputput.putline(ret_msg);
end;
I get error
ORA-02064: distributed operation not supported
remote procedure does not have any commit statement.
Need assistance on this
Thanks
Archana