Friday, August 29, 2008

tapiGen Update Released

I've been extremely busy the last couple months.  So much so that I have not had the time to add some of the  functionality that I know tapiGen needs, such as the ability to process associative arrays. I did, however,  add one process that has been saving me all kinds of time: TAPI_GEN.PUT_APEX_FORM_CODE. It is for that reason that I'm releasing this update.

You pass in a table name and an ApEx page id and the procedure outputs four blocks of code which can be used to create page level processes built on tapiGen:

  1. A process to fetch a record and populate page items.
  2. A process to create.
  3. A process to modify.
  4. A process to delete.

The output is created via DBMS_OUTPUT.PUT_LINE so make sure you have output enabled before executing this procedure. The resulting code can be used as is or as a starting point of sorts from which you can make any customizations needed.

Eventually I'd like to be able to create forms declaratively as you're able to do now using ApEx wizards. However, an API to do so has not yet been released so this is the best I can do for now. I hope to get another release out soon with more functionality. If you have any suggestions/requests add them at or send me an email.


  1. Don,

    Have you considered creating the TAPI templates in XSL, rather than storing them in a PL/SQL module?

    Using the table's XML (obtained fro DBMS_METADATA), you can do transformations to generate the TAPIs (and it's fast).


  2. Kevan,

    No, I had not considered that. To be honest, this project has kind of been put on the back burner due to lack of interest - it's very hard to get people into TAPIs.

    Steven Feuerstein has already created something like what you described. I recommend you check it out.

    I was trying to develop something a little more light weight.