SOA Purge Db Scripts Fails With the Errors Like PLS-00364: loop index variable 'GVSESS_REC' use is invalid (Doc ID 2679483.1)

Last updated on JULY 07, 2023

Applies to:

Goal

On : 12.2.1.2.0 version, Deployment

SOA purge db scripts fails with the following error

it says "Warning: Package Body created with compilation errors."
and deep down we see error as

SQL> alter procedure check_purge_session compile
  2 ;

Warning: Procedure altered with compilation errors.

SQL> show errors
Errors for PROCEDURE CHECK_PURGE_SESSION:

LINE/COL ERROR
-------- -----------------------------------------------------------------
7/5 PL/SQL: SQL Statement ignored
8/11 PL/SQL: ORA-00942: table or view does not exist
22/11 PL/SQL: Statement ignored
22/43 PLS-00364: loop index variable 'GVSESS_REC' use is invalid
23/11 PL/SQL: Statement ignored
23/43 PLS-00364: loop index variable 'GVSESS_REC' use is invalid
24/11 PL/SQL: Statement ignored
24/43 PLS-00364: loop index variable 'GVSESS_REC' use is invalid

How does one resolve the issue?
 

Solution

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