My Oracle Support Banner

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

Last updated on MARCH 28, 2019

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.