Re: Problem about pro*c

zhanggp wrote:
> i want to insert a large amount of data into oracle with pro*c. when i use
> arrays like 'exec sql for :n ...', it is faster.
>
> Does pro*c send oracle sql statement and oracle compile it and execute or
> pro*c compile the statement and execute it?

The server compiles it. (HINT: look at the OCI .C program after the Pro*C precompiler has parsed the source .pc file.)

>
> Does arrays insert compile the insert statement once or compile it n times?

I think it is compiled only once.

> it saves time because bulk data of the network transfer or the compile time
> of sql statement?

Likely a little of both.

Good that you are interested in learn the WHYs of ORACLE.

HTH

-- 
Ed Prochak
running: http://www.faqs.org/faqs/running-faq/
family:  http://web.magicinterface.com/~collins
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost