Re: Stored procedures for OracleDb

sb wrote:
> Hi All,
>
> I am in a dilemma where I wastoldby other developers in my team that
> complex stored procedures are not used for accessing oracledb where the
> tables return millions of rows of data. Is this true? The smarts after
> retrieving the data is done in business objexts using Pro C.
> This OracleDb is 10g.
> Please advise.

Not true.

Nothing will benefit from using Pro*C unless it is very CPU intensive and then I'd still head straight for natively compiled PL/SQL rather than Pro*C.

Let me guess. What other quaint version 7 habits do they have?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)