-
Distributed Transaction Problem in DBMS_REPCAT.CREATE_MASTER_REPOBJECT
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
-
I think this is a Bug.
Get the latest ODBC driver patch for 8.1.5.x or 8.1.6.x.
In the Data Source Configuration, check the option to "Disable Microsoft Transaction Server".
http://metalink.oracle.com/metalink/...T&p_id=95451.1
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|