Re: Possible to call a procedure/function via ODBC?

From: <jocave_at_my-deja.com>
Date: Thu, 05 Oct 2000 01:59:53 GMT
Message-ID: <8rgnan$2q9$1@nnrp1.deja.com>

In article <39dbbb2c.31506881_at_news.ma.ultranet.com>, ronin_at_ultranet_spam_.com (Ronin) wrote:
> Hello:
>
> I hope this isn't too foolish a question...
>
> Is it possible to call a database procedure/function that resides in
> the Oracle Database via ODBC? I know you can submit queries with
> ODBC, but I haven't been able to find documentation that indicates how
> to call a procedure.
>

If you're trying to execute a stored procedure via an ODBC connection, you can execute the query

SQLExecDirect
{call yourStoredProcedure( 'your', 'arguments', 'here' )}

Look at SQLBindParameter to see how to dynamically bind arguments for the procedure rather than specifying them explicitly.

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. Received on Wed Oct 04 2000 - 20:59:53 CDT