Forms 14.1.2 - unable to compile form: misplaced START WITH clause
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.