Hi chee hee,

I am just curios about your reason to generate so many SP.
I think you want to use this for your DAL, but my questions is:
if all will be generated won't be more easy to generate the
Insert/Update/Delete instead of so many SP?
I don't say it is bad or good I want to know only your point of view.

On 7/4/07, chee hee <hee_cm18@...> wrote:
>
> Hi All,
>
> I am putting all database manipulation code into stored procedures. For
> each table, there will be INSERT, UPDATE, SELECT, and DELETE stored
> procedures.
> Considering my application consists of almost 200 tables, this will create
> 800 stored procedures for tables plus many others. Total stored procedures
> could easily reach 1000.
>
> In Oracle we can group them together using Package, but not in Firebird.
> I am seeking advise from someone who has done this before as what is the
> best approach? How do we manage these stored procedures?
>
> Thanks.
>
> regards,
> CM
>
> Send instant messages to your online friends http://uk.messenger.yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>



--
Best regards,
Dragos Hilbert mailto:dragos.hilbert@...
----------------------------------------------------------------------------------------------------------------


[Non-text portions of this message have been removed]