Syntax

sqlCallStoredProcedureWithOutParams(datasourceName, procedureName, [params])

Package

sql

Alias

Pkg Usage

callSPWithOutParams(datasourceName, procedureName, [params])

Description

Executes the stored procedure over the defined datasource.

Executes the stored procedure over the defined datasource.

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.

See also