| Table plus |
|---|
| applyColStyleToCell | true |
|---|
| columnTypes | s,s,s,s |
|---|
| heading | 0 |
|---|
| 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.
...
| Table plus |
|---|
| 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
...
| 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 |
|---|
|