Calling stored procedure with out parameters using ODBC

[Wombat]

Hi,

I am using VC++ and ODBC. I need to call an oracle stored procedure that has has in and out parameters.

The ExecuteSQL method of CDatabase doesn't allowed for out parameters. So if anyone can give me any ideas or some simple example as to go about implementing it?

Thanks.

[Wombat]

Any suggestions guys?

[OReubens]

Overrride CDatabase::BindParameters and set your own output parameter(s).

[Arjay]

Use the ATL OLEDB consumer classes. It makes working with stored procs a snap. No Dsn required either.