function, alter user, dblink ? Problem? [oracle]

Hi,
I have a problem when I traied execute function to dblink:

CREATE OR REPLACE FUNCTION password_change(LOGIN VARCHAR2, pass VARCHAR2)
RETURN VARCHAR2 IS
    V_SQL varchar2(200);

         Kom varchar2(200);
  BEGIN
   V_SQL := 'ALTER USER ' || UPPER(LOGIN) || ' IDENTIFIED BY
"'||pass||'"';

   EXECUTE IMMEDIATE V_SQL;    Kom := 'OK ' ||LOGIN||' - '||pass;
   RETURN Kom;

END; I execute:

declare
  i varchar2(200);
begin
  i := aaa.password_change_at_DGH('test','qwe123');   dbms_output.put_line(i);
end;

when I execuce I get error:
"ORA-02064: distributed operation not supported"

My question is:
How use alter user with dblink.????

Sorry for my english.

Luk Received on Fri Jan 12 2007 - 02:33:49 CST