Need Sample ODBC call to execute a SQL stored procedure

We are coding our first interface that needs to execute a SQL stored procedure and read the return values.  Does any one have an example of how to connect, execute, and process the result row set from a SQL stored procedure.  

The SQL stored procedure uses one input (Account Number) and returns a record set with the Physician Numbers and Names that are associated with the Account Number.

Thank you in advance for any assistance.