Solution: IB V6.01
Executing stored procedures with ODBC is a little different than with other connections. To execute a stored procedure that returns a result set the statement would be as follows:
select * from procedure_name
This will return a result set in this format:
Field1 | Field 2 |
=========== | =========== |
value | value |
value | value |
value | value |
value | value |
To execute a procedure that returns only an output variable the statement would be:
execute procedure procedure_name
This will return a variable similiar to this:
Variable
= = = = = = = = = = =
value
Last Modified: 11-JUL-01