Re: Pro C Exectution

Dear

I've used Pro*C for years and the oracle part in it is just like you would write C. Just pop all your SQL inside EXEC SQL and END EXEC statements. They will execute when the code is hit. Your normal C code will start executing again when the block of Pro*C is finished, just like any ordinary block of code.

Regards, Gerrit-Jan Linker
Developer of Oraxcel and OraDebug
http://members.aol.com/gjlinker

Robert Pritchard <robert_pritchard_at_tertio.com> writes:

>I'm not completely sure if this question is 100% relevant to this group
>but I would appreciate any advice.
>Can someone explain to me how a ProC statement is executed and what the
>difference is between an EXECUTE IMMEDIATE statement and a standard one.
>
>I appreciate that it is executed immediately but I am unsure what this
>means in relevance to a standard query. Are the standard queries queued?
>Or executed in blocks of x? Or whatever.
>I would very much appreciate any insight that anyone can offer.
>Thank you in advance
>Rob
>
Received on Mon Jan 25 1999 - 17:09:33 CST