Execute dynamic SQL from Oracle Forms


FORMS_DDL built-in or DBMS_SQL database package are used to execute dynamic SQL from Oracle Forms. 

Example:


FORMS_DDL('INSERT INTO X VALUES (' || col_list || ')');


Note that FORMS_DDL will force an implicit COMMIT and de-synchronize Oracle Forms.

Comments

Popular posts from this blog

Create Tables in Oracle Database using TOAD

How to create Oracle stored Procedures using TOAD for Oracle

How to Create Packages in Oracle Database using TOAD for Oracle