How to execute a procedure call in ODBC Test

By: Borland Staff

Abstract: How to execute a procedure with ODBC Test

Problem:
Don't know how to execute a procedure call in ODBC Test

Solution:
IB V4.x
visigenic InterBase ODBC driver v2.00.903

To execute a procedure in ODBC Test with the prepare statment, following
these steps:

1)  Connect to a database. 
2)  Enter the call command in the input Window:
     {call procedure_name('input')}
3)  Select SQLPrepare from the Statement Menu and click OK.
4)  Select SQLExecute from the Statement Menu and click OK.
5)  Select GetDataAll from the Results Menu, if the procedure returns values.

Server Response from: ETNASC03