Clicky
Skip to Content
Custom Search

Reply to comment

Anonymous

 

 

 

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!

Reply

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

    More information about formatting options

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

Navigation

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

 

Share this if you liked it!

 

Disclaimer



Number of Registered users 713
Theme by Dr. Radut.