Sun Adapter for Oracle Tutorials

ProcedureRun the project

  1. Rename one of the trigger files included with the sample, from filename.in.~in to filename.in in the target file, to run the corresponding operation. For example, rename TriggerDelete.in.~in to TriggerDelete.in to run the delete file operation.

    The Where Clause defined in the business rule recognizes the trigger as a placeholder for input, allowing a set condition, such as emp_no = 100, to determine the type of output data.

    You can modify the following input files to view different output.

    • TriggerTableSelect.in

    • TriggerDelete.in

    • TriggerUpdate.in

    Having no content in these files causes the operation to read all records.

  2. Verify the output data by viewing the sample output files. The output files may change depending on the number of times you execute the sample Project, the input file, and also the content of your database table.