db link .... error ora-2074

From: George D. Benetos <gbenet_at_intranet.gr>
Date: Tue, 2 Apr 2002 15:03:36 +0300
Message-ID: <a8c6pa$cmo$1@newsserv.intranet.gr>

I'm trying to call a package of a remote database using a link . I get the following result ...
What this package really does , is to make an insert to a table ...

SQL> exec tms_trace.print_at_almdb('TMS_HOUSEKEEP',1,'GBENTEST'); begin tms_trace.print_at_almdb('TMS_HOUSEKEEP',1,'GBENTEST'); end;

*
ERROR at line 1:

ORA-02074: cannot ROLLBACK in a distributed transaction
ORA-06512: at "OTE8004.TMS_TRACE", line 146
ORA-02074: cannot ROLLBACK in a distributed transaction
ORA-06512: at "OTE8004.TMS_TRACE", line 91
ORA-08002: sequence ADMS_TRACE_LOG.CURRVAL is not yet defined in this session
ORA-06512: at line 1

When i make the insert statement , it works ...

insert into adm_trace_log_at_almdb(TRACENO,LOGMESSAGE) values(100000,'test'); commit;

What is the difference ?
Can i call a package using a db link or not ??

thanx .....

George D. Benetos
Electrical & Computer Engineer N.T.U.A

Received on Tue Apr 02 2002 - 06:03:36 CST