Software related information one might find useful.
Here's how to print the result of any cursor in Oracle PL/SQL: Print the result of a cursot in Oracle PL/SQL
While researching information about ETL tools, I've come across with this IBM RedBook about its InfoSphere DataStage product:
You can get IBM InfoSphere DataStage Data Flow and Job Design here. I also recommend InfoSphere DataStage Parallel Framework Standard Practices.