Forum Discussion

Manog1978's avatar
Manog1978
Icon for Neophyte rankNeophyte
3 years ago

PLSQL call the function using Groovy

Hi  I have datasource and embadded Groovy Script configured, the database team created custom function as scheduler status to monitor job status., begin   -- Call the function   :result := dbodat...
datasource
groovy
kendall's avatar
kendall
Icon for LM Champion rankLM Champion
3 years ago

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!