Problem about pro*c

From: zhanggp <zhangguoping_at_boco.com.cn>
Date: Sun, 2 Mar 2003 11:16:24 +0800
Message-ID: <b3rsrr$2asj$1@mail.cn99.com>

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?

Does arrays insert compile the insert statement once or compile it n times? it saves time because bulk data of the network transfer or the compile time of sql statement? Received on Sat Mar 01 2003 - 21:16:24 CST