1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-02041: Client Database didn't begin transaction ORA-02063: Preceding line DB link

Discussion in 'General' started by venu57, Jan 13, 2015.

  1. venu57

    venu57 Active Member

    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    100
    Location:
    Bangalore
    Hi,

    I have written a package in Development which will create a database user in test and production environments.

    The above package calling(using db link)one more procedure which is there in production and test environments.
    we are calling the package in front end tool. whenever we try to create a new user, we are getting the below error .

    ORA-02041: Client Database did not begin transaction ORA-02063: Preceding line from <DB link name>

    Note: When we checked, the user is creating successfully in Prod Environment and not in Test Environment.

    Our oracle Prod version is 10.2.0.4.0 and Dev Db version is 10.2.0.4.0 and Test Db version is 10.2.0.5.0.

    Does 10.2.0.5.0 has any strictness on remote calls?

    Please provide your valuable suggestions asap.

    Thank You.
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Re: ORA-02041: Client Database didn't begin transaction ORA-02063: Preceding line DB

    Hi.

    The ORA-2063 indicates that this must be done at the remote database.

    See the link Calling Remote Procedures


    OS version ?