My Oracle Support Banner

ORA-31150, ORA-06553, ORA-06550, PLS-00302 from DBMS_XDB_REPOS.deleteresource (Doc ID 2043074.1)

Last updated on AUGUST 11, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

During upgrade from 11gR2 to 12c, errors were encountered while migrating ACL's to 12c implementation:

...
11:56:32 SQL>
11:56:32 SQL> -- Migrate network ACLs from XDB (moved from xsa112)
11:56:32 SQL> @@nacla112.sql
11:56:32 SQL> Rem
11:56:32 SQL> Rem $Header: rdbms/admin/nacla112.sql /main/4 2012/10/07 18:34:25 rpang Exp $
...
11:56:32 166        dbms_xdb_repos.delete_recursive);
11:56:32 167    end if;
11:56:32 168
11:56:32 169  end;
11:56:32 170  /
declare
*
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string
ORA-06512: at "SYS.XS_OBJECT_MIGRATION", line 167
ORA-06512: at line 28
ORA-06512: at line 69


After the upgrade to 12c, deleting the XDB resource related to the old 11g ACL's is failing with errors:

SQL> CALL DBMS_XDB_REPOS.deleteresource('/sys/acls/http_test_cbl.xml');
CALL DBMS_XDB_REPOS.deleteresource('/sys/acls/http_test_cbl.xml')
   *
ERROR at line 1:
ORA-31150: uncaught error in handler SYS.DBMS_NETWORK_ACL_ADMIN.handlePreDelete
ORA-06553: PLS-313: 'HANDLEPREDELETE' not declared in this scope
ORA-06553: PLS-313: 'HANDLEPREDELETE' not declared in this scope
ORA-06550: line 1, column 34:
PLS-00302: component 'HANDLEPREDELETE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "XDB.DBMS_XDB_REPOS", line 355
ORA-06512: at line 1

Changes

Upgraded from 11gR2 to 12c.

Cause

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
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.