Subject Re: [firebird-support] Compile Stored Procedures?
Author Helen Borrie
At 02:45 PM 19/09/2003 +0200, you wrote:
>Is it possible to compile stored procedures?

Yes, stored procedures must be compiled.

>So that nobody can see the sourcecode?

You can remove the sourcecode once the procedure is compiled:

update rdb$procedures
set rdb$procedure_source = null
where rdb$procedure_name = 'SOME_NAME';

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

SPs and UDFs don't do the same kinds of jobs. SPs do SQL and operate on
tables. UDFs are just functions and operate on constants.