My Oracle Support Banner

Using FINAL Keyword Within FOR Loop Throws ORA-29536 Error (Doc ID 2294860.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Java stored procedure fails with "ORA-29536 badly formed source error", if FINAL keyword is used within "for-each/for" loop. The same code works fine as a standalone Java program. 

Changes

Issue is due to OJVM source compiler which makes use of SQLJ parser for the javac grammar whenever a "create java source" has to be parsed. In this case OJVM source compiler failed to identify the FINAL keyword in loop causing the error

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.