You can interact directly with a data source within a BPEL process by using the Data Access system service. Using this service, you create an invoke activity that executes one or more SQL statements on a specified data source and receives a result set as the response.

The Data Access service provides two operations:

execSQL

and

execMultiSQL

. These operations allow you to execute either a single SQL statement or multiple SQL statements. You can execute any SQL statement, whether you are selecting, inserting, updating or deleting data or stored procedures from a data source.

During deployment, you must specify the target data source.