ITP uses SQL SELECT statements to retrieve data from Oracle databases for Data Retrieval and Key Retrieval. The Field definitions in the Entry describe the columns that are retrieved through the SELECT statement.
The UPDATE statement can be used to create a DID defined function that updates the database. However, an DID defined function always expect some kind of result set to return to the ITP model. Therefore the SQL statement that is used to update should have a format like UPDATE …. WHERE …. SELECT 1. Without such a statement an error will occur.
At the moment ITP is not capable to use other SQL statements then SELECT, such as CREATE or call Stored Procedures or Stored Functions.