Organizational Research By

Surprising Reserch Topic

understanding the differences between table and transaction apis


understanding the differences between table and transaction apis  using -'oracle,design,design-patterns,api,plsql'

Friends,

This Ask Tom thread  which I found via another SO question, mentions Table and Transactional API's and I'm trying to understand the difference between them.  

A Table API (TAPI) is where there is no access to the underlying tables and there are "getters" & "setters" to obtain information.

For example to select an address I would:

   the_address := get_address(address_id);


Instead of:

   select the_address
   from some_table
   where identifier = address_id


And then to change the address I would invoke another TAPI which takes care of the change:

   ...
   change_address(address_id, new_address);
   ...


A Transactional API  (XAPI) is again where there is no direct access to modify the information in the table but I can select from it? (this is where my understanding is kind of hazy)

To select an address I would:

   select the_address
   from some_table
   where identifier = address_id


and then to change it I would call

   ...
   change_address(address_id, new_address);
   ...


So the only difference I can see between a TAPI and a XAPI is the method in which a record is retrieved from the database, i.e. a Select Versus a PL/SQL call?  

Is that it? or have I missed the point entirely?
    
asked Sep 24, 2015 by manju bhargava
0 votes
3 views



Related Hot Questions



Government Jobs Opening


...