|Subject||Re: [firebird-support] Re: Unsuccessful execution on delete FB 3 SP source code|
On Thursday, June 13, 2019, 4:41:12 PM GMT+3, Dmitry Yemanov dimitr@... [firebird-support] <firstname.lastname@example.org> wrote:
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
> 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