| Subject | Re: [firebird-support] Compile Stored Procedures? |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-09-19T13:05:29Z |
At 02:45 PM 19/09/2003 +0200, you wrote:
update rdb$procedures
set rdb$procedure_source = null
where rdb$procedure_name = 'SOME_NAME';
tables. UDFs are just functions and operate on constants.
heLen
>Hello!Yes, stored procedures must be compiled.
>
>Is it possible to compile stored procedures?
>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.
heLen