Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02064: distributed operation not supported using dblink

Agowda-OracleSep 14 2011 — edited Jul 17 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2012
Added on Sep 14 2011
4 comments
10,156 views