Using FINAL Keyword Within FOR Loop Throws ORA-29536 Error
Last updated on AUGUST 16, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms