You can embed PL/SQL in C quite easily without having to resort to OCI, by
using Pro*C. Instead of the keywords EXEC SQL, you use EXEC SQL BEGIN. Check
the Oracle documentation for Pro*C. It's online at
http://technet.oracle.com.
--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.
Michael Krolewski wrote in message <36A23A7F.AC1F76E4_at_u.washington.edu>...
>You can use the OCI functions --- a bit cumbersome -- or OTL a C++ library
that
>someone (who?) has to reduce some of the overhead and add streams.
>
>Assuming the stored procedure exists in your database you can create a
parsed
>startment like
>
>char someParsed[] = "begin\n"
> " thatStoredProcedure( arg1, arg2,
arg3 );
> "end;";
>
>Using the appropriate functions, you can get IN OUT parameters or returned
>values.
>
>Mike Krolewski.
>
>amerar_at_theocc.com wrote:
>
>> Hello,
>>
>> Can anyone tell me the utility I need to preprocess embedded PL/SQL that
is
>> within a C or C++ program?
>>
>> Please send responses to e-mail.
>>
>> Thanks,
>>
>> Arthur
>> amerar_at_theocc.com
>>
>> -----------== Posted via Deja News, The Discussion Network ==----------
>> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
>
Received on Sun Jan 17 1999 - 19:22:03 CST
