Database DataWarehousing (MOSC)

MOSC Banner

ORA-02046 - distributed transaction already begun

edited Sep 24, 2019 5:00AM in Database DataWarehousing (MOSC) 10 commentsAnswered
Dear All,

I would be very grateful for your help.....

I am running a procedure in a package that accesses a view on another database through a database link.

I get the above error on the server....

I set an event  '10046 trace name context forever, level 4' and produced a trace file.

I tkprofed it and all it showed the sql that was causing the problem, with a statement '

'The following statement encountered a error during parse:  ORA-02046

The document mentions that it is possible from a DBLINK after an error...

The alert log does not show the error.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center