SQL & PL/SQL

Hi all..

Sorry to ask this question again, I think this question might be asked several time in this forum.


I have a remote_function

Database Name: remote_database
function_name : remote_function

remote_function { }
{
update table or synonym set column = 'example'; -- table is in remote_database (database name)
commit;
}

i have another database..

database_name: local_database
database_link: remote_dblink (connect to remote_database from local_database)

I am calling the remote function from local_database like this...


exec remote_function@remote_dblink ();

but i am getting an error.. distrubuted transaction not supported..

How can i get rid of this error? Please help me with this.