Unfortunately i couldnt combine the queries as i have logic which determines what data to update.
Also i tried looking at the below link but could know where i need to update the flag: https://issues.apache.org/jira/browse/GROOVY-8397?page= com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel& focusedCommentId=16273333#comment-16273333 Sorry i tried googling around the issue but didnt find anything relavent On Thu, May 10, 2018 at 12:08 PM, Daniel.Sun <[email protected]> wrote: > Hi Avinash, > > FYI, > https://issues.apache.org/jira/browse/GROOVY-8397?page= > com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel& > focusedCommentId=16273333#comment-16273333 > https://stackoverflow.com/questions/12192592/java-sql- > sqlexception-ora-01000-maximum-open-cursors-exceeded > > In addition, I suggest you try to combine update statement and select > statement and execute only one statement, or write an anonymous block > `BEGIN...END` to finish your query and update. > > Cheers, > Daniel.Sun > > > > -- > Sent from: http://groovy.329449.n5.nabble.com/Groovy-Users-f329450.html > -- Regards Avinash
