Skip to Content
Custom Search

Reply to comment





Hi All,

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!


  • Allowed HTML tags:
      1. Lines and paragraphs break automatically.

    More information about formatting options

    This question is for testing whether you are a human visitor and to prevent automated spam submissions.


Click the +1 button  below to share it with your friends and colleagues


Share this if you liked it!



Number of Registered users 713
Theme by Dr. Radut.