Creating, Reading, Updating, and Deleting Records

You can use methods to perform the following operations on off-screen records when you click a button:

  • Create record. You can create a record and specify the record type, its fields, and their values.

  • Read record. You can retrieve the fields from a record. You can specify the record type, record row ID, and a list of field names to be returned with their values.

  • Update record. You can update a record identified with a specific row ID. You can specify the field names and values to update the record.

  • Delete record. You can delete a record identified with a specific row ID.

For all of these create, read, update, and delete (CRUD) operations, you must have access to the record. If you do not, then the operation fails. You must implement a callback function to handle the results of the CRUD operation, when they become available. For information about the CRUD methods, see Methods for CRUD Operations.

Note: For the CRUD operations, only top-level record types and not child-level record types are supported.
Tip: Use the Oracle CRM On Demand REST API for data manipulation with off-screen records. The REST API is more powerful for data manipulation of off-screen records and it has more functionality such as support for CRUD operations on child-level record types. For more information, see Oracle CRM On Demand REST API Developer’s Guide.