DECLARE
P_BOOKINGS_SK NUMBER;
BEGIN
P_BOOKINGS_SK := ?;
DELETE FROM F_BOOKINGS WHERE BOOKINGS_SK = P_BOOKINGS_SK;
DELETE FROM B_BOOKINGS_INVOICE WHERE BOOKINGS_SK = P_BOOKINGS_SK;
DELETE FROM B_BOOKINGS_QUOTE_SN WHERE BOOKINGS_SK = P_BOOKINGS_SK;
DELETE FROM F_OIC WHERE BOOKINGS_SK = P_BOOKINGS_SK;
DELETE FROM F_OIC_BOOKINGS_BRIDGE WHERE BOOKINGS_SK = P_BOOKINGS_SK;
DELETE FROM D_BOOKINGS WHERE BOOKINGS_SK = P_BOOKINGS_SK;
END;
step 1
ole db command should have a input
step 2
under the tab of input and output properties , create external columns ( when you create multiple columns , note the parameter sequence should be same as the external columns sequence )
