luccaya
9 years agoNew Contributor
call a stored procedure with groovy
Hello all,
I'm trying to call a stored procedure in groovy script and I got the error : Could not find matching constructor for groovy.sql.Sql.
The code is :
import groovy.sql.Sql
new Sql(DataSource).sql.call '(call CLONE_HE_SPEC(?,?)}',[747,sql.INTEGER], {he_spec_id -> println he_spec_id
}