My Oracle Support Banner

ORA-00904 and PLS-00364: loop index variable 'L_LOB_REC' use is invalid error while validating APPS.WF_DIAGNOSTICS package (Doc ID 2829704.1)

Last updated on DECEMBER 23, 2021

Applies to:

Oracle Workflow - Version 12.2.7 to 12.2.7 [Release 12.2]
Information in this document applies to any platform.

Symptoms

alter package apps.WF_DIAGNOSTICS compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors

Errors for PACKAGE BODY APPS.WF_DIAGNOSTICS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2629/4 PL/SQL: SQL Statement ignored
2631/16 PL/SQL: ORA-00904: "NOUT"."USER_DATA"."GET_STRING_PROPERTY":
invalid identifier

2653/6 PL/SQL: Statement ignored
2653/15 PLS-00364: loop index variable 'L_LOB_REC' use is invalid
2833/4 PL/SQL: SQL Statement ignored
2835/16 PL/SQL: ORA-00904: "NIN"."USER_DATA"."GET_STRING_PROPERTY":
invalid identifier

2856/6 PL/SQL: Statement ignored
2856/15 PLS-00364: loop index variable 'L_LOB_REC' use is invalid

 

Changes

 Database was exported/imported as part of a platform migration to Exadata

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.