Stored procedure


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


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.


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

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

println resultSet