Re: Calling a stored procedure from C++

"Dave Pylatuk" <davep_at_centurysystems.net> wrote in message news:<Ios4a.3319$iu1.352328_at_news20.bellglobal.com>...
> Hello, I have an Oracle 8.1.7 and am able to execute the following
> statement from SQL Plus with no problem.
>
> exec update_cascade.on_table('some_table');
>
> it also works fine with 'execute' instead of 'exec', it
> also works fine with just:
>
> update_cascade.on_table('some_table');
>
> I am somewhat new to C++ and am not sure how to call this
> procedure from code. Can anyone provide me with a code
> example of how to do this ?
>
> Thanks in advance

You can do it from ProC as follows:
EXEC SQL
EXECUTE
BEGIN
view_bill_data ( :customer_id, :order_id ); END;
END-EXEC;
where customer_id and order_id simple C variables of type int Received on Thu Feb 20 2003 - 10:31:06 CET