sqlCallStoredProcedure

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