Subject Re: [firebird-support] Firebird Stored Procedures
Author Dragos Hilbert
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
> [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]