> thanks for the reply, i want to continue to use sql procedures, not java fucntions (or other languages).
>
> thanks for the suggestion, my application doesn't have an heavy db usage so also if calling sub procedures is not optimal is not a problem (if in future we begin to have performance problem i will remember your suggestion :) )
>
> i'm using fb 2.5 superclassic on windows.
>
> maybe what i'm asking is related to the ui application used to manage the db (i'm using flame robin that is very simple and with few tools),
> i want only same way to group / hide procedures to better organize them, so it will be more easy to manage them.

Either it's a tool feature, to e.g. define some kind of workspace, but
then it's for that particular tool only.

Firebird 3 will have a new object type called packages (like in Oracle),
which allows you organize your PSQL routines natively.



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!