Hi Marc,

> Is it possible to compile stored procedures? So that nobody can see the

sourcecode?

>
> Or do I have to use UDFs then. Please help!

Upon creation, stored procedures, triggers and check constraints _are_
compiled.

The source (BEGIN... END... etc) is stored so you can retrieve the text.

If you browse the system tables, for procedures: RDB$PROCEDURES, you
will notice a column RDB$PROCEDURE_BLR - this column holds the
compiled version of the procedure, while RDB$PROCEDURE_SOURCE
holds the textual version. You can set RDB$PROCEDURE_SOURCE to
anything you like, once the procedure has been created.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com