Distributed procedure call.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 26 Jul 1999 15:38:12 +0100
Message-ID: <933000108.20158.0.nnrp-14.9e984b29@news.demon.co.uk>

I have a database on 8.0.4 on NT, which I am using to run the following (stripped to the bare minimum) script:

declare

     m_on_free_list number;
begin

      dbms_space_remote.free_blocks(


           'SYS',


           'DUAL',


           'TABLE',


           0,
           m_on_free_list,
           50
      );

end;
/

There is a synonym DBMS_SPACE_REMOTE which can point to one of two databases. The first is 8.0.4 on an HP on a local network, the second is 8.0.5 on NT over an IDSN line.

I regularly execute SQL like:

        insert into {local table}
        select from {remote table}

quite freely.

All databases are set to handle distributed transactions.

BUT -
    When I execute this script against the 8.0.4 database is works,     When I execute it against the 8.0.5 database I get:

        declare
            *
            ERROR at line 1:
            ORA-02055: distributed update operation failed; rollback
required
            ORA-06512: at line 4

I can't find any clues on MetaLink.
Any ideas, anyone ?

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk Received on Mon Jul 26 1999 - 09:38:12 CDT