View previous topic :: View next topic
|
Author |
Message |
services
New User
Joined: 20 May 2009 Posts: 38 Location: India
|
|
|
|
In our project we are trying to call an oracle procedure from Mainframe using pro*cobol.
Problem Description:
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).
Thanks |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
Back to top |
|
|
|