> 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?

With a clear naming convention so you can find a particular stored
procedure easily.

Most of the third-party Firebird development tools have wizards to
create such SUID procedures with your pre-defined naming convention.




--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com