PLSQL call the function using Groovy

I think the import statement you’ll need for the necessary library is:

import groovy.sql.Sql

And because it’s Oracle, you’ll also need:

import oracle.jdbc.driver.OracleTypes

Then you’ll need to create a sql object, something similar to this:

Sql sql = Sql.newInstance("jdbc:oracle:thin:@hostname:1521:dbname", "username","password","oracle.jdbc.driver.OracleDriver") 

And finally, insert your sql query inside parentheses, like this:

sql.call()

Hope this helps get you started!