Comment by Bob on Manually creating a Logical Change Record (LCR)

That was excellent!

I was having a little trouble when I was setting p_table_owner to a schema other than my own (I even have DBA and the select on all_tab_columns was successful).

Statement:

v_lcr.set_value(‘new’, ‘first_name’…

was throwing that ‘first_name’ did not exist in the LCR.

Once I copied the table to my own schema, works great!

Good for now – exactly what I needed – trying to develop the DML_Handlers before Streams is up and running.