[Home] [Help]
570: PROCEDURE set_message_notification(
571: streams_name IN VARCHAR2,
572: notification_action IN VARCHAR2,
573: notification_type IN VARCHAR2 DEFAULT 'PROCEDURE',
574: notification_context IN SYS.ANYDATA DEFAULT NULL,
575: include_notification IN BOOLEAN DEFAULT TRUE,
576: queue_name IN VARCHAR2 DEFAULT 'streams_queue');
577:
578: -- streams_name : The name specified in add_message_rule for DEQUEUE
1173: -- invoker of the api will be used.
1174: -- column_name: The new name of the column.
1175: -- column_value: The value to place in this new column. The
1176: -- type of the column will be determined by the
1177: -- type held within the AnyData. For now, this
1178: -- is limited to scalar values.
1179: -- value_type: Whether to add the old or new columns in the lcr.
1180: -- Specify 'old' or 'new'.
1181: -- step_number: The order relative to other transformations.
1184: PROCEDURE add_column(
1185: rule_name IN VARCHAR2,
1186: table_name IN VARCHAR2,
1187: column_name IN VARCHAR2,
1188: column_value IN SYS.ANYDATA,
1189: value_type IN VARCHAR2 DEFAULT 'NEW',
1190: step_number IN NUMBER DEFAULT 0,
1191: operation IN VARCHAR2 DEFAULT 'ADD');
1192: