Feature Release

new generated API functions / procedures

• adding a row_exists_yn function that returns 'Y' or 'N', same functionality as the existing row_exists function but allows to check a row within SQL context
• adding additional read_row functions that takes unique constraint columns as parameter and returns the row, for each unique constraint one read_row function
• new enable INSERT, UPDATE, DELETE parameter for fine granular definition, which DML operations are allowed on the table
• optional DML view as logical layer above the database table. This can be used in e.g. in APEX instead of the table to create forms, interactive grids etc AND to ensure, that table API is used
• optional DML view trigger that additionally catches unallowed DML operations and throws exceptions in dependency of new enable INSERT, UPDATE, DELETE parameter

code optimizations

• getter functions for each column: remove unnecessary variable declaration (variable v_return)
• setter functions for each column: remove unnecessary variable declaration (variable v_#column_name#)
• limit clause for bulk collect operations introduced to avoid session memory conflicts

other stuff

• added some additional comments on internal procedures and functions
• renaming internal variables more consistently
• supporting special column names, by using quotes around column names and validating / converting parameter names