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 |