...
Parameter name | Type | Required | Description |
---|---|---|---|
datasourceName | string | yes | The datasource Datasource name or JNDI name. For JIRA Jira database, this is set to "jdbc/JiraDS" by default. |
procedureName | string | yes | the stored Stored procedure name. |
The routine accepts multiple parameters, in this case the sql statement being pushed as prepared into the database (check the second example . Check Example 2 below for the correct syntax).
Returns
string []
Notes
Note |
---|
Please notice that this routine work This routine works only with Oracle stored procedures. The parameters with type "OUT" must have three properties (corresponding parameter name from the procedure, data type, type), while the other ones must have four (corresponding parameter name from the procedure, data type, type, value). |
...
SQL Type | SIL Type |
---|---|
User-defined collection | ARRAY |
CHAR | CHAR |
NUMBER | DECIMAL |
NUMBER | FLOAT |
NUMBER | INTEGER |
LONG | LONG |
REF CURSOR | REF CURSOR |
DATE | TIMESTAMP |
VARCHAR2 | VARCHAR2 |
Notes
Note |
---|
To see how you should configure the data source , check the corresponding configuration chapter: SQL data sources configuration chapter. |
See also
Filter by label (Content by label) | ||||||||
---|---|---|---|---|---|---|---|---|
|
...