sqlCallStoredProcedureWithOutParams

Owned by Jonathan Muse
Last updated: Oct 11, 2024 by Shane Smith
1 min read

Description

Executes the stored procedure over the defined datasource.

Parameters

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