I was using SQLProcedureColumns() to retrieve the input/output parameter information of a stored procedure. It happens that there are two stored procedures with the same name in my test database, but they have different parameter lists. When I pass the procedure name to SQLProcedureColumns(), it returns to me *all* the parameters from both of the functions. For example,

StoredProc1(param1)
StoredProc1(param2, param3)

Calling SQLProcedureColumns() will return param1, param2 and param3 as the result.

Is there a way to correctly tell which stored procedure I am actually referring to? It seems that SQLProcedureColumns() is limited by the API itself and only accepts procedure name (and other schema name) as the argument.

Any help would be appreciated.

Thanks.