update()

The Database.update() function updates the database with values contained in the concept.

Tip: XMLType  In order to update an Oracle Database table column of datatype XMLType with a string value greater than 4,000 characters, you must add the following Oracle JAR files to BE_HOME/lib/ext:
  • ORACLE_HOME/rdbms/jlib/xdb.jar
  • ORACLE_HOME/lib/xmlparserv2.jar

Example

try
  {
   Database.setCurrentConnection ("/MyDbConnection");
   Database.beginTranscation ();
   /*the instance passed to update operation is an instance of the      dbconcept*/
   Database.update(instance)
   Database.commit();
  }
catch (Exception e)
  {
    Database.rollback();
  }
finally
  {
    Database.unsetConnection();
  }
Related reference