Hi Community!
I'm trying to use some groovy code to do an update according to a list. Well, I'm having some bad time, probably because my code have something wrong.
import groovy.sql.Sql
def lista = []
Sql sql = BonitaSql.newInstance("jdbc:oracle:thin:@MYIPADRESS:orcl1", "NAME", "PASS",new oracle.jdbc.OracleDriver())
sql.eachRow "SELECT CD_USUARI FROM VULTIMOLOG WHERE DAT < (sysdate - 20)", {lista +=it.CD_USUARI}
sql.close()