Question: Updating a database table

[Avinash Nanda]

Hi All,

This is my first post here,I am using groovy 2.4.13

Problem: I need to update a value in the oracle database for large
table(754508 records)

Error: Max cursors exceeded

Here is a same code i am using

selectQuery = "select stament goes here"
updateQuery = "Update query with parameters"

sql.row(selectQuery).each{it ->
             sql.execute(updateQuery, [it.name])}
sql.close()

This throws max cursors exceeded and i dont know how to resolve it. Any
help would be appreciated.

Also let me know if there is any additional information is needed.

-- 
Regards
Avi