How to maintain data in temporary tables oracle 11g
Posted on 2014-07-18
We have an application , in that we have the reports generation option . We have an report for generating products brought by the customers and their price , product groups info etc. As part of the process , we insert the customers to whom the data needs to be generated in an temporary table , from this table within the procedure , we process the data and calculate the data for the report send it as an ref cursor back to the java program.
Now we have an additional requirement , we need to send the customer branch and fee details as an separate report and send to the same java program.For this new report , we need the customer data stored it the temporary table to be re-used for the second report.
Proc 1 : Inserts data into the Temp1 temporary table
Proc2 : Fetch the customer details from temp1 table , and then get the branch and fee details
Can any one help me , is there any means to store the data inserted in temp1 table from proc1 and get the data from proc2.
First proc1 is called , it inserts the data into temp1 table , processes and send the data to java app. After getting data from proc1 , proc2 is invoked , which needs data inserted from proc1.
Any help in this regard is really appreciated.