Reply to comment
I have declared and opened a cursor in program A and before fetching the data from cursor, program A calls another program B.
Program B has a commit statement. After the call to program "B", the fetch is issued on the cursor, would the data be fetched or there will be an sql error stating that the cursor is closed.
What I exactly wish to know is that if a Cursor is opened without Hold option in a calling program and the called program issues a commit, would the cursor be closed?
Any inputs are welcome!