Create the bpTableSelect Business Process

1. From the Projects window, right-click your new project and select New -> Business Process from the shortcut menu.

2. Rename your new business process to bpTableSelect.

3. Add the following activities to the bpTableSelect Business Process canvas.

   • FileClient.Receive (CAPS Components Library -> Adapters -> File -> FileClient)

   • FileClient.Write

   • FileClient.Write

   • FileClient.Write

   • DB_EMPLOYEESelectAll (prjOracle_BPEL -> otdALL -> otdOracle)

   • marshal (prjOracle_BPEL -> otdALL -> otdInputDTD_DB_employee)

4. Connect the following activities: (See image below for details)

   • Start -> FileClient.receive

   • FileClient.receive -> FileClient.write

   • FileClient.write -> otdOracle.DB_EMPLOYEESelectAll

   • otdOracle.DB_EMPLOYEESelectAll -> otdInputDTD_DB_employee.marshal

   • otdInputDTD_DB_employee.marshal -> FileClient.write

   • FileClient.write -> FileClient.write

   • FileClient.write -> End