I have come up with a requirement i.e. We have Oracle Student Systems Applications, Whenever students adds the unit course to their Enrollments one of the base table gets inserted with the student details and the units the students has selected. As soon as the record is inserted into Oracle Students System Applications Base tables an database trigger fires and the same record is inserted into a Oracle custom table so that WM can picks the data and do the necessary data conversion and write it to a file.
I know how to write the data picked by WM to a file. I was wondering How can I pick the data that was inserted by database trigger into Oracle Custom table.
Can anybody let me know how to initiate the process? Can anybody let me know the steps to make this happen?
Thank you very much in advance.