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 that does not return a result set, simply run the stored procedure. Depending on the database, the syntax may be different. For example, to run a stored procedure in Pervasive.SQL you type CALL <stored procedure name>. In Oracle, type EXEC <stored procedure name>. In Microsoft SQL Server, type EXEC <stored procedure name> or simply the name or the stored procedure with no keyword.