Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center