Info |
---|
|
This routine is available starting with SIL Engine™ 3.0.3. |
Syntax
...
Table plus |
---|
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
Table plus |
---|
applyColStyleToCell | true |
---|
columnTypes | s,s,s,s |
---|
heading | 0 |
---|
multiple | false |
---|
enableSorting | false |
---|
|
Parameter name | Type | Required | Description |
---|
datasourceName | |
...
...
Yes | Datasource name / JNDI name. For Jira database, this is set to "jdbc/JiraDS" by default. | procedureName |
|
...
...
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
...
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 showMessageaddComponent() is a String id, String name) 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.
...
Note |
---|
To configure the data source, check the SQL |
...
See also
Filter by label (Content by label) |
---|
showLabels | false |
---|
max | 25 |
---|
showSpace | false |
---|
cql | label = "sqlsystem_support"routines" and space = currentSpace ( ) |
---|
labels | sqlarray_supportroutines |
---|
|