My Oracle Support Banner

CATPROC INVALID with error - "PLS-00201: identifier 'DBMS_SQL' must be declared" (Doc ID 2318148.1)

Last updated on DECEMBER 06, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 After applying PSU CATPROC is INVALID. 

================
Component Status
================

Comp ID Component                          Status    Version        Org_Version    Prv_Version
------- ---------------------------------- --------- -------------- -------------- --------------

APEX    Oracle Application Express         VALID     3.2.1.00.12
APS     OLAP Analytic Workspace            VALID     11.2.0.4.0
CATALOG Oracle Database Catalog Views      VALID     11.2.0.4.0
CATJAVA Oracle Database Java Packages      VALID     11.2.0.4.0
CATPROC Oracle Database Packages and Types INVALID   11.2.0.4.0

 

Changes

 Applied PSU

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


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