|Subject||Re: [firebird-support] Firebird Stored Procedures|
> Hi All,With a clear naming convention so you can find a particular stored
> 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?
Most of the third-party Firebird development tools have wizards to
create such SUID procedures with your pre-defined naming convention.
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and