Re: calling stored procedure mfrom vc++

In article <svpuae3ig6kif3_at_corp.supernews.com>,   krithika <krithika_net_at_rediffmail.com> wrote:
> hi
> i have connected oracle with vc++ using odbc
> how should i call stored procedures from vc++ and pass parameters to
> oracle

A couple of options

SQLExecDirect( '{call yourStoredProcedure( 'param1', 'param2' )}', ...

or

SQLPrepare( '{call yourStoredProcedure( ?, ? )}', ... SQLBindParameter
SQLBindParameter
SQLExecute

--
Justin Cave - Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of
Oracle Corporation.


Sent via Deja.com http://www.deja.com/
Before you buy.