Looking for the documentation on the newest versions of SIL Engine and the Simple Issue Language for Jira 8? Click here and leave these dusty old pages behind!
Availability
This routine is available starting with SIL Engine™ 3.0.3.
Syntax
sqlCallStoredProcedure(datasourceName, procedureName, [...])
Description
Executes the stored procedure over the defined datasource name / JNDI datasource.Parameters
Parameter name | Type | Required | Description |
---|---|---|---|
datasourceName | string | yes | Datasource name / JNDI name. For Jira database, this is set to "jdbc/JiraDS" by default. |
procedureName | string | yes | Stored procedure name. |
The routine accepts multiple parameters, in this case the sql statement being pushed as prepared to the database. Check Example 2 below for right syntax.
Returns
string []
Example
Example 1
string [] results = sqlCallStoredProcedure("myDB", "showMessage");
Where showMessage() is a stored procedure existing in myDB database.
Example 2
string [] results = sqlCallStoredProcedure("myDB", "addComponent", "componentId", "componentName");
Where addComponent(String id, String name) is a stored procedure existing in myDB database.
Notes
To configure the data source check the SQL data sources configuration chapter.
See also