Hi,

I am already doing the naming convention method.
Currently I have SP under names like TABLE_NAME_S, TABLE_NAME_I, TABLE_NAME_U, and TABLE_NAME_D and they are almist 800 of them.

Thanks,
CM


----- Original Message ----
From: Pavel Kutakov <pvk@...>
To: firebird-support@yahoogroups.com
Sent: Thursday, July 5, 2007 3:46:04 AM
Subject: [firebird-support] Re: Firebird Stored Procedures

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

As already said, choose proper naming convension. You can add single
prefix for all access procedures to group them visually in the list.
For example, you may use "ZZZ_" prefix to put all these procedures to
the bottom of the list.
Also almost all mordern development tools have a feature to group
objects in the user-created tree. So you may create any kind of
virtual "packages" and fill them as you need.

--
Best regards,
Pavel Kutakov
SQLLY Development
Firebird Development Studio - complete development solution.
http://www.sqlly com




Send instant messages to your online friends http://uk.messenger.yahoo.com

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