Dbms_Wm.Mergeworkspace Error - ORA-01001: Invalid Cursor

(Doc ID 1662168.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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


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.


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