DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Distributed Transaction Problem in DBMS_REPCAT.CREATE_MASTER_REPOBJECT

  1. #1
    Join Date
    May 2003
    Posts
    32

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    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
  •  


Click Here to Expand Forum to Full Width