13.06.2019 13:43, 'Mr. John' mr_johnmr@... wrote:

> Using FB 3.0.4/Windows 10x64 ,I'm trying to delete SP source code as
> worked in 2.5:
>       UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL WHERE
> RDB$SYSTEM_FLAG IS NULL  OR RDB$SYSTEM_FLAG=0;
>
> bun now on FB 3 tried:
>
> update RDB$PROCEDURES set rdb$procedure_source = NULL where
> rdb$procedure_name
> STARTING WITH 'MYPR_'
>
> and got
> Unsuccessful execution caused by a system error that precludes
> successful execution of subsequent statement s.
> UPDATE operation is not allowed for system table RDB$PROCEDURES.

Try adding one more condition to your WHERE clause:

(...) and RDB$PROCEDURE_SOURCE is not null


Dmitry