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 and later
Information in this document applies to any platform.


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  /
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


Upgraded from 11gR2 to 12c.


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

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.