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.
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