sqlCallStoredProcedureWithOutParams
Description
Executes the stored procedure over the defined datasource.
Syntax | sqlCallStoredProcedureWithOutParams(datasourceName, procedureName, [params]) | Package | sql |
Alias |
| Pkg Usage | callSPWithOutParams(datasourceName, procedureName, [params]) |
Parameters
Parameter name | Type | Required | Description |
|---|---|---|---|
datasourceName | String | Yes | Datasource name or JNDI name. For Jira database, this is set to "jdbc/JiraDS" by default. |
procedureName | String | Yes | Stored procedure name. |
Return Type
String []
Examples
Where showMessage() is a stored procedure existing in myDB database.
string [] results = sqlCallStoredProcedureWithOutParams("myDB", "showMessage");Where INSERTTEST is a stored procedure existing in myDB database, you can see it below:
string [] results = sqlCallStoredProcedureWithOutParams("myDB", "INSERTTEST", {"p_userid", "FLOAT", "IN", "1.22"}, {"p_username", "VARCHAR2", "IN", "username"}, {"p_createdby", "VARCHAR2", "IN", "admin"}, {"p_date", "TIMESTAMP", "IN", "28-APR-2015"});To configure the data source, check the SQL data sources configuration chapter.