DDL ХП: допускается ли в скрипте точка с запятой после завершающего 'end' ?

set term ^;
create or alter procedure p1 returns(x double precision) as
begin
  x=rand()*10000;
  suspend;
end
;
;^set term ;^
commit;

set term ^;
create or alter procedure p1 returns(x double precision) as
begin
  x=rand()*10000;
  suspend;
end
;
;/*lorem ipsum dolor sit amet*/^set term ;^
commit;

Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 7, column 1
-;

SQL> show version;
ISQL Version: LI-V2.5.2.26448 Firebird 2.5
Server version:
Firebird/linux AMD64 (access method), version "LI-V2.5.2.26448 Firebird 2.5"
on disk structure version 11.2

Posted via ActualForum NNTP Server 1.5

Posted via ActualForum NNTP Server 1.5

Posted via ActualForum NNTP Server 1.5

SQL> set term ^;
SQL> create or alter procedure p1 returns(x double precision) as
CON> begin
CON>   x=rand()*10000;
CON>   suspend;
CON> end
CON> ;
CON> ;^set term ;^
SQL> commit;
SQL> set blob all;
SQL> select rdb$procedure_source from rdb$procedures where rdb$procedure_name='P1';

RDB$PROCEDURE_SOURCE
====================
              0:3
==============================================================================
RDB$PROCEDURE_SOURCE:
begin
  x=rand()*10000;
  suspend;
end
==============================================================================

Posted via ActualForum NNTP Server 1.5

Posted via ActualForum NNTP Server 1.5