My Oracle Support Banner

PLS-00302: component 'FROM_REMOTE' must be declared After RDBMS Upgrade To 12.2 (Doc ID 2482720.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

Any pl/sql referencing some particular packages, such as DBMS_REPUTIL will get invalid with error PLS-00302 after database upgrade to 12.2.

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/12     PL/SQL: Statement ignored
3/28     PLS-00302: component 'FROM_REMOTE' must be declared

Changes

 Upgraded RDBMS from 11g or 12.1 to release 12.2.

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


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