Using Stored Procedures with ODBC

Abstract: Using Stored Procedures with ODBC

Problem: I want to execute stored procedures and connect to Interbase using their ODBC Driver

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:

Field1Field 2
======================
valuevalue
valuevalue
valuevalue
valuevalue

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