I am trying to configure to replicate date for the table dbt_m_bank where the branch_code=729.

I am able to replicate all insert & Delete operation on that table. But i am facing to problem in Update operation. The below is the script to handle Update operation which is giving error. Please check the script or suggest how to handle UPDATE operation using add_subset_rule.

Configure in Destination Database.

<Connect as your Streams Administrator, eg STRMADMIN>

rem Create DML handler procedure

CREATE OR REPLACE PROCEDURE EBAMEND_DML_HANDLER(in_any IN SYS.ANYDATA)
IS

It is useless to create a new topic with the same question.
Streams was introduced late in 9.2. It does not work very well in this version, most of those who use Streams use it in 10.2, so if you don't have answer maybe nobody knows the answer or maybe it will take time for someone knowing it to read your post (did you read all mine?), so be patient or call Oracle support.