sqlCallStoredProcedure
- Service Account
- Jonathan Muse
- Elena Kolesnik
Looking for the documentation on the newest versions of SIL Engine and the Simple Issue Language for Jira 8 for Server/Data Center? Click here !
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