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