Retrieving data from a data connection by using an SQL expression

You can use an SQL expression to retrieve data by using your choice of SQL, or by invoking a stored procedure. This mechanism returns a single value, which is the value of a single column in the first row of the result set returned by the SQL expression, or by the stored procedure call if you have chosen to use stored procedures.

  • Using an SQL expression to retrieve a value from a data connection
    By using an SQL expression, you can use your choice of SQL to retrieve data from a table. Only a single field is returned. Therefore, if multiple rows are returned by the SQL, all but the field from the first row is discarded.
  • Using an SQL expression to run stored procedures
    Stored procedures can be invoked at run time. The procedure is referenced in a business object field. At run time, if a value for the business object field is required for event rule evaluation or action object creation, the procedure is invoked and the resulting value is returned as the value for the business object field. Any required parameters can also be passed as part of the stored procedure call.
Parent topic: Retrieving data from data connections