Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Question about parse

Question about parse

From: Antonio Pascual <apa_at_jerez.micro.lucent.com>
Date: Thu, 10 Jun 1999 13:29:54 +0200
Message-ID: <7jo7mh$rvp@nntpb.cb.lucent.com>


Hi all.

I have a loop that make about 1000 insertions in a table. The program use the OCI.
Every time i have to make oopen, oparse y oexec.

I want to increase the performance of the program. I think that i could put the oopen out of the loop. But i don't know what to do with oparse. Why i have to parse each sentence if all are equal, and are good?.

I think thah i could use stored procedures.

Could you help me? Received on Thu Jun 10 1999 - 06:29:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US