Stored procedure

Purpose

Execute a stored procedure and return the results. Stored procedures are either ‘UserDefined’ or are part of a reserved set provided with Platform 6.

Methods

Binding name: sproc


Method: String[][] execute( entityName, procedureName, Map parameters )

Executes the named procedure on the named storage entity using the Map of parameters. The return type is a list of list of Strings.

Examples

Map mapParams = new HashMap()
mapParams['Adapter ID'] = 'groovy'

def resultSet = sproc.execute( 'UserDefined', 'PROC1', mapParams )

println resultSet