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]