PL/SQL Table API Generator

Package to generate the rich Table API for Oracle.

• DML operation procedures
• Data retrieval funcions for the whole table record or ID by ROWID, primary key or any nonfunctional unique indexes
• Bulk DML operations
• Insert from cursor
• Record type for the table with default values
• Dynamic primary key generation from sequence

To generate API package for a table execute:

	:c := tapi_codegen.gen_package_for_table(par_owner => USER, par_table_name => 'TAPI_TEST_1');

Package code is returned as CLOB (:c).

You can generate and compile the package automaticaly by executing

	tapi_codegen.generate_and_compile(par_owner => USER, par_table_name => 'TAPI_TEST_1');

• Bulk DML api with exception handling
• Multilevel entities with primary key as foreign key
• Custom exception handling block
• Cursors for retrieval by columns with foreign key

The authors of TAPI-Codegen are

• Pavel Kaplya (Pazus)
• Artur Baytin

See the (LICENSE) file for license rights and limitations .