/
sqlCallStoredProcedure

sqlCallStoredProcedure

Owned by Jonathan Muse
Last updated: Nov 19, 2024

Description

Executes the stored procedure over the defined datasource name / JNDI datasource.

Parameters

Return Type

String []

Examples

Example 1

Where showMessage() is a stored procedure existing in myDB database.

string [] results = sqlCallStoredProcedure("myDB", "showMessage");

Example 2

Where addComponent(String id, String name) is a stored procedure existing in myDB database.

string [] results = sqlCallStoredProcedure("myDB", "addComponent", "componentId", "componentName");

To configure the data source, check the SQL data sources configuration chapter.

See also

Peacock

Related content