Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

WITH Clause in Forms 12.2.1.4

Dan KingAug 5 2024

Has anyone found a way (or confirmed that if it is even possible) to use a WITH clause inside a record group? I'm using 19c 19.3 and Forms 12.2.1.4 running in Windows 10?

This simple query would return “FRM-12001: Cannot create the record group (check your query).”
with t as (select table_name tab from all_tables) select tab from t

Thanks.

Comments
Post Details
Added on Aug 5 2024
1 comment
235 views