Subject | Unsuccessful execution on delete FB 3 SP source code |
---|---|
Author | Mr. John |
Post date | 2019-06-13T10:43:01Z |
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 statements.
UPDATE operation is not allowed for system table RDB$PROCEDURES.
that seems to be fixed: [#CORE-4507] Unable delete procedure source on Firebird 3.0 Alpha 2.0 - Firebird RDBMS Issue Tracker
"The ability to explicitly set the source code to NULL is restored. All other kinds of direct modifications are still prohibited"
but not working
thanks for any help