Dbms_Wm.Mergeworkspace Error - ORA-01001: Invalid Cursor (Doc ID 1662168.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Workspace Manager - Version 10.2.0.5 and later
Information in this document applies to any platform.

Symptoms

ORA-01001: invalid cursor

when merging workspace, where one of version enabled tables holds about 50 FK constraints.
As an ORA-01001 invalid cursor error is a program logic problem, they believe it has something to do
with WMSYS.LT or related WM's package or function.

===
SQL> exec Dbms_Wm.Mergeworkspace('PR1002340');
BEGIN Dbms_Wm.Mergeworkspace('PR1002340'); END;

*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "WMSYS.LT", line 6043
ORA-06512: at line 1
===

No other errors was found in error stack.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms