Re: advantages of storing SQL in stored procs

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 22 Aug 2000 20:32:14 +0800
Message-ID: <39A272CE.525@yahoo.com>

NetComrade wrote:
>
> I ask/make my developers to write SQL using bind vars, are there any
> clear advantages in doing it in PL/SQL, performance wise?
>
> Thanx.

Using pl/sql should improve the likelihood of sharing common SQL's (thus lowering your parsing)...

In reality, this is more dependant on the discipline you can install on your developers...I've seen many places where they have 37 versions of what is basically the same SQL, all in a single "shared code" library..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Tue Aug 22 2000 - 07:32:14 CDT