PLSQL call the function using Groovy

Thank for your suggestion. i have defined the same in datadource.

import groovy.sql.Sql

// Set host variables.
def databaseName = instanceProps.get("wildvalue")
def host = hostProps.get("system.hostname")
def user = hostProps.get("oracle.${databaseName.trim()}.user") ?: hostProps.get("jdbc.oracle.user")
def pass = hostProps.get("oracle.${databaseName.trim()}.password") ?: hostProps.get("jdbc.oracle.pass")
def port = hostProps.get("oracle.${databaseName.trim()}.port")?.toInteger() ?: (hostProps.get("jdbc.oracle.port")?.toInteger() ?: 1521)
def queryOutput = [:]
def conn = [:]

However, i am unable to define the below function 

begin

  -- Call the function

  :result := database_tools.get_scheduler_status(status_code => :status_code);

end;

Please provide some sample query.