Data Loading from View in remote(db link) into oracle table
848964Apr 2 2013 — edited Apr 2 2013Hi,
For an e-business inbound interface, my interface data is present in a remote view accessed via db link. I just need to get that data into Oracle and also want to have something such that whenever there is any insertion in dblink view, my table in oracle also updated with the new row.
So I want to have the data from db link view to be loaded in the table and at the same time whenever there would be insertions in that view, my table should be autopopulated.
Most of my research revolved round ref cursor but not able to get anything definite. The requirement seems to be simple.
Any hints on the same.
Regards,
Ad