...
| applyColStyleToCell | true |
|---|---|
| heading | 0 |
| columnTypes | s,s,s,s |
| multiple | false |
| columnAttributes | style="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold, |
| enableSorting | false |
...
Syntax
...
sqlCallStoredProcedure(datasourceName, procedureName, [...])
...
Package
...
sql
...
Alias
...
Pkg Usage
...
callSP(datasourceName, procedureName, [...])
Description
| Excerpt | ||
|---|---|---|
| ||
| Executes the stored procedure over the defined datasource name / JNDI datasource. |
Executes the stored procedure over the defined datasource name / JNDI datasource.
Parameters
...
| applyColStyleToCell | true |
|---|---|
| columnTypes | s,s,s,s |
| heading | 0 |
| multiple | false |
| enableSorting | false |
...
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.
Return Type
String []
Examples
Example 1
Where showMessage() is a stored procedure existing in myDB database.
| Code Block | ||
|---|---|---|
| ||
string [] results = sqlCallStoredProcedure("myDB", "showMessage"); |
Example 2
Where addComponent(String id, String name) is a stored procedure existing in myDB database.
| Code Block | ||
|---|---|---|
| ||
string [] results = sqlCallStoredProcedure("myDB", "addComponent", "componentId", "componentName"); |
| Note |
|---|
To configure the data source, check the SQL data sources configuration chapter. |
See also
| Filter by label (Content by label) | ||||
|---|---|---|---|---|
| showLabels | false | |||
| max | 25 | |||
| showSpace | false | |||
| cql | label = "system_routine" and space = currentSpace ( ) | labels | array_routines||
| Include Page | ||||
|