java.sql.SQLSyntaxErrorException: ORA-04044: procedure, function, package, or type is not allowed he
2 node oracle BMS cluster in GCP
oracle 19.19
We have a 2 node BMS RAC cluster in GCP and its version is 19.13. Recently we upgraded it to 19.19. After upgrade completes , we used to face the below error while running jobs.
java.sql.SQLSyntaxErrorException: ORA-04044: procedure, function, package, or type is not allowed here
we have a JOB table under a schema called XXX_XX and also has a PUBLIC synonym for this XXX_XX.JOB table. When the jobs started running after this 19.19 upgrade complets, they used to see ORA-04044 error. At this time , i recreated this PUBLIC synonym JOB then all jobs are running fine.