Hello!
I m coding a module for creating Oracle Replication Environment.
While i m executing the DBMS_REPCAT.CREATE_MASTER_REPOBJECT package,
it returns me back with the following error.
In a test scenerio i havent used any option for Distributed Transaction.

ORA-02074: cannot ROLLBACK in a distributed transaction
ORA-06512: at "SYS.DBMS_REPCAT_UTL4", line 2662
ORA-02074: cannot SET SAVEPOINT in a distributed transaction
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 4381
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2608
ORA-06512: at "SYS.DBMS_REPCAT", line 562
ORA-06512: at line 1

My test code is:
strSN = "Oracle.Net"
strUserName = "pls"
strUserPW = "mvlzdfwx2mvlzdfwx786"

strCommandText = " BEGIN " & _
" DBMS_REPCAT.CREATE_MASTER_REPOBJECT ( " & _
" gname => 'PLS_MG', " & _
" type => 'TABLE', " & _
" oname => 'MD', " & _
" sname => 'PLS', " & _
" use_existing_object => TRUE, " & _
" copy_rows => TRUE); " & _
" END; "



Dim objConn As New ADODB.Connection
strConnectionString = "Provider=OraOledb.Oracle.1" & _
";Password=" & strUserPW & _
";Persist Security Info=True" & _
";User ID=" & strUserName & _
";Data Source=" & strSN
Call objConn.Open(strConnectionString)
objConn.BeginTrans
Dim objCommand As New ADODB.Command
objCommand.CommandText = strCommandText
Set objCommand.ActiveConnection = objConn
Set rRS = objCommand.Execute
objConn.CommitTrans
ExecuteCommand = True

Call objConn.Close

End Sub


Suggesstions.

RAFF