Reattaching Orphaned Object From Lost+Found Fails With Errors ORA-6510 ORA-6512 (Doc ID 259325.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Repository - Version: 6.5 to 9.0
This problem can occur on any platform.
Lost+Found Container
JR_FOLDER.REATTACH_OBJECT (Repository API).

Symptoms

Reattaching a container (folder or application) from Lost+Found container via SQL*Plus as explained in <<Note:122501.1>> fails with the following errors:

    SQL>execute jr_context.set_workarea ('<WORKAREA_NAME'>');  
    SQL>execute jr_folder.reattach_object(<IVID object>, <IRID Container>);
    BEGIN
    jr_folder.reattach_object(<IVID object>, <IRID Container>);
    *
    ERROR at line 1:
    ORA-06510: PL/SQL: unhandled user-defined exception
    ORA-06512: at "REPOS_MANAGER.JR_FOLDER", line 709
    ORA-06512: at line  1

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