Forum Discussion

luccaya's avatar
luccaya
New Contributor
8 years ago

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

}