| Warning |
|---|
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 ! |
| Info | ||
|---|---|---|
| ||
This routine is available since katl-commons starting with SIL Engine™ 3.0.3. |
Syntax
...
sqlCallStoredProcedure(datasourceName, procedureName, [...])
Description
...
| Excerpt |
|---|
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 into to the database (check the second example . Check Example 2 below for right syntax).
Returns
...
string []
Example
...
Example 1
...
| Code Block |
|---|
string [] results = sqlCallStoredProcedure("myDB", "showMessage");
|
Where showMessage() is a stored procedure existing in myDB database.
Example 2
...
| Code Block |
|---|
string [] results = sqlCallStoredProcedure("myDB", "addComponent", "componentId", "componentName");
|
Where addComponent(String id, String name) is a stored procedure existing in myDB database.
Notes
...
| Note |
|---|
To see how you should configure the data source , check the corresponding SQL data sources configuration chapter: SQL Data Sources. |
See
...
also
| Filter by label (Content by label) | labels | |||||
|---|---|---|---|---|---|---|
|
|
|