Subject Re: [firebird-support] Re: Firebird 3: Not able to UPDATE RDB$Procedures
Author Dimitry Sibiryakov
31.05.2018 18:14, blackfalconsoftware@... [firebird-support] wrote:
> However, maybe Firebird 3.x.x does NOT allow this as Carlos' manual suggests...

I've just trued:

SQL> show version;
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-V3.0.2.32703 Firebird 3.0"
on disk structure version 12.0
SQL> create procedure aaaaaa as begin /* */ end;
SQL> select rdb$procedure_source from rdb$procedures where rdb$procedure_name='AAAAAA';

RDB$PROCEDURE_SOURCE
====================
1a:1e0
==============================================================================
RDB$PROCEDURE_SOURCE:
begin /* */ end
==============================================================================

SQL> update rdb$procedures set rdb$procedure_source=null where rdb$procedure_name='AAAAAA';
SQL> commit;
SQL> select rdb$procedure_source from rdb$procedures where rdb$procedure_name='AAAAAA';

RDB$PROCEDURE_SOURCE
====================
<null>


--
WBR, SD.