Using Stored Procedures in SQL Utility

This topic contains information about the legacy SQL Utility, which is being phased out from GainSeeker Suite. It is still available for use in version 8.3, but is being replaced by the new GainSeeker SQL Utility function in the GainSeeker Utility module.

Call stored procedures

You can call stored procedures from the SQL Utility. To do this you must be in Execute SQL Mode.  See SQL Utility Execute SQL Mode Example for more information.

To execute a stored procedure, consult your database documentation for the appropriate syntax. The simplest method of calling a stored procedure uses the following syntax:

• Microsoft SQL Server and Oracle databases: EXEC stored_procedure_name

• MySQL and Pervasive.SQL databases: CALL stored_procedure_name