Oracle Forms (MOSC)

MOSC Banner

Forms 14.1.2 - unable to compile form: misplaced START WITH clause

edited Apr 9, 2025 9:37AM in Oracle Forms (MOSC) 1 commentAnswered ✓

I'm referencing this thread:
https://community.oracle.com/mosc/discussion/4575621/forms-12-2-1-19-unable-to-compile-form-misplaced-start-with-clause

According to 23ai documentation

You can start h. query with connect by OR start with.

Setting FORMS_PLSQL_BHVR_COMMON_SQL=TRUE before compiling the form solves this error but brings another big problem.

The form that contains commit in pl/sql does not commit data to the database, and we must replace commit with commit_form.

As per documentation, setting FORMS_PLSQL_BHVR_COMMON_SQL=TRUE in the env file will change commit behavior but not compile the form.

Also, the same problem with reports.

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