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

Home -> Community -> Usenet -> c.d.o.tools -> Embedded SQL vs Stored Procedures

Embedded SQL vs Stored Procedures

From: Gama Franco <gama_franco_at_clix.pt>
Date: Tue, 07 Sep 2004 17:10:29 +0100
Message-ID: <chkm5u$2lla$2@pegasus.fccn.pt>


Hi,

I'm using OCCI to develop a new aplication, but I have one doubt about the most efficient way to make an operation. The operation makes inserts some rows in different tables, and also creates some new tables. I would like to know if it is faster to compute this kind of operations if they are hard codded in OCCI, or using a stored procedure that recieves all the parameters needed and takes care of the insertions and creations.

Best regards,
Gama Franco Received on Tue Sep 07 2004 - 11:10:29 CDT

Original text of this message

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