Oracle ODBC Driver does not allow DEFAULT parameters

Can anyone confirm this, because I can find no documentation on it.

I have a PL/SQL procedure with several parameters that have DEFAULT values, which is being called from a C++ app using ODBC. If I try just omitting the parameter markers in the procedure call, SQLExecDirect simply fails and I get no errors or diagnostic records using either SQLGetDiagRec or SQLError. If I try placing parameter markers in the procedure call then specify to the driver that I want to use the default values using the following SQLBindParameter call

    SQLINTEGER sqldefault=SQL_DEFAULT_PARAM;

    rc = SQLBindParameter(hstmt,

                          5,
                          SQL_PARAM_INPUT,
                          SQL_C_CHAR,
                          SQL_CHAR,
                          0,
                          0,
                          NULL,
                          0,
                          &sqldefault);

I get an error when I try to execute the procedure that says "Driver not capable".

Does anyone know for certain if there's a way to use default parameters of if it's simply not supported?

TIA,
Josh Miller Received on Mon May 15 2000 - 00:00:00 CDT