My Oracle Support Banner

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 OCTOBER 25, 2021

Applies to:

Oracle SOA Suite - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

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

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
Goal
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.