Embedded SQL vs Stored Procedures

[Gama Franco]

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

[Jeff]

How complex the operations are and how often they will be done would be
determining factors for me. In most senarios, SP are more efficient... so
unless the operations are extremely simplistic, like one or two statements...
or too complex, requiring too many outside parameters, and/or they are very
rarely done, such that maintaining a SP seems like overkill, I'd choose using
a SP or package.

Long response made short, IMHO, use a SP.