18.4 generate table api (tapi) upd only selected columns

I'm going to say:   NO.

The problem with PL/SQL is that it is ALL-OR-NOTHING with the parameters being used.

You either use all parameters, or you use no parameters (ie don't call the procedure)

PL/SQL does not have a "did you use this parameter?" syntax similar to the UPDATING( column_name) syntax for DML operations.

Workaround:

• Install the "oddgen" plugin for SQL*Developer:  ( https://github.com/oddgen  )
• Install one of the template based code generators
  • FTPDB ( https://github.com/ftldb/ftldb  )
  • tePLSQL ( https://github.com/osalvador/tePLSQL  )
  • jk64 ( https://bitbucket.org/jk64/jk64-sample-apex-tapi  -- i couldn't find the site in 4 clicks.  My google skills are bad )
• Build your own template
  • try to base it on an existing one.
• Build a wrapper for "oddgen"
• Have fun.

My Solution (in a tePLSQL template)

This is a common problem (especially in APEX Forums)

I solved this problem by adding another column that tells the procedure "which columns to modify".  (type col_list_t)

Example Result of my "View on APEX Collection" template (using tePLSQL)

Re: A "Wizard Progress List Template" to save data in a single table

My $0.02

MK

Paavo wrote:

 

Mike Kutz you mentioned in another thread that there was oddgen forum, do you know where it moved - github?

 

rgrds Paavo

The "oddgen" add-in for SQL*Developer is on GitHub  oddgen

The Oracle Community section "oddgen" was moved to /dev/null  (that is: it was removed)

You (or ThatJeffSmith) would need to contact Steven Feuertein about "what happened?"

For global design of the multitude of packages, read up on smartdb

      https://asktom.oracle.com/pls/apex/f?p=100:551:::NO:551:P551_CLASS_ID,P551_STUDENT_ID:3241,&cs=1ACD5C67F5535FEDE29BE14FF… 

For generic "How should this Function look like?" question, I'd ask in the SQL & PL/SQL forum.

For "how to implement it using _____ code generator engine?",  I'd ask in their respective GitHub/BitBucket location.

MK

• "oddgen"
• template based code generator engines ( FTLDB, tePLSQL, jk64, etc)
• code templates

All of these are used to create the "ui pkg, business logic pkg, more generic pkg" DDLs.

Once you have a Package you want to create, you can turn it into a Template for a specific Template Based Code Generator Engine.

Once you have a Template, you can create the Code Generator (a PL/SQL Package of a specific format) for "oddgen" (see the README.md for "oddgen")

Once that is created, you'll see it in the drop-down.

I don't have any TAPI templates (right now) except that VIEW-on-APEX-Collection one. Its not listed here because it is only on my Home system

MK