WebSphere Adapter for Oracle E-Business Suite

Modifying the delete operation

This task is optional. In this sample application, WebSphere® Adapter for JDBC is set to pass a delete operation to the server for customer objects that are identified as inactive by event data sent from Oracle. If you do not want the adapter to pass a delete operation for an inactive customer, modify a SQL script to change the operation from delete to update.

About this task

This task is only necessary if you want change the operation the Adapter for JDBC performs on customers that have become inactive in the Oracle database.

With Oracle E-Business Suite, you can make a customer inactive and modify data for an inactive customer, but you cannot delete customer data from the base tables. When the stored procedure used for inbound processing receives event data from Oracle that indicates a customer has become inactive, it sets the operation to delete for the customer object and then posts that information to the event table used by the Adapter for JDBC. The adapter uses that information to process the object and pass it to WebSphere Process Server. However, if you want to keep the customer object in WebSphere Process Server rather than deleting it, edit the sample SQL package to change the operation that the adapter reads from the event table.

How to perform this task

  1. Access the samples files, and open the ibm_customer_event_pkg.pls file in a text editor.
  2. Remove the following statement from the script:
    IF v_status <> 'A' THEN
      v_object_function := 'Delete';
    END IF;
  3. Save the script.
  4. Run the script using the SQL* Plus tool or a similar tool for processing SQL statements.

Terms of use |

Last updated: Mon 30 Oct 2006 03:46:27

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)