PLS-00364: loop index variable ‘SYN_REC’ use is invalid

I got ” PLS-00364: loop index variable ‘SYN_REC’ use is invalid ”  error in Oracle database.

PLS-00364: loop index variable ‘SYN_REC’ use is invalid

Details of error are as follows.

When running the Validate Apps Schema process in adadmin the following error appears:

declare
*
ERROR at line 1:
ORA-06550: line 25, column 11:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 3, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 46, column 10:
PLS-00364: loop index variable 'SYN_REC' use is invalid
ORA-06550: line 45, column 5:
PL/SQL: Statement ignored

loop index variable ‘SYN_REC’ use is invalid

This PLS-00364 error is related to the loop index variable.

select GRANTEE, PRIVILEGE from dba_sys_privs  where GRANTEE = ‘APPS’;

‘ SELECT ANY DICTIONARY’ should be listed

To solve this error, Perform the following select in sqlplus:

select GRANTEE, PRIVILEGE from dba_sys_privs  where GRANTEE = 'APPS';

  
If ‘SELECT ANY DICTIONARY‘ is not listed, then contact your sysadmin to discuss the grant then retry the above sql.

You can give the permission as follows.

grant SELECT ANY DICTIONARY to apps;

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )