In our project we are trying to call an oracle procedure from Mainframe using pro*cobol.
Using pro*cobol Mainframe we will establish a connection to oracle once and will have to pass around 10 million rows to an oracle procedure one by one. The oracle proc will process each row and send the o/p back to mainframe, then the next row will be passed. While this happens the session status in the oracle swithches between Active and Inactive status causing a huge delay in the process.
It would be very helpful if some one can help me why the status goes inactive. The oracle trace shows majority of time is spent idle (Sql*net from client event).