---In firebird-support@yahoogroups.com, <jonatan.lauritsen@...> wrote :

>

> I am trying to create or modify the following procedure:
>
> create or alter procedure test_procedure(id integer, p_from_date date)
> as
>
>   declare variable from_date date;
>   declare variable to_date date;
>
> begin
> end  
>
> But this SQL restarts server or the connection remains hanging (from IBExpert or from Flamerobin).
> This problem is in Firebird 3.0.0 and 3.0.1 (64 bit). There are no relevant messages in firebird.log
> (e.g. no gds exceptions).

  I can't reproduce it:

\Firebird-3.0.0.32483-2_x64_pdb>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> set sql dialect 1;
SQL> create database 'a.fdb';
SQL> show version;
ISQL Version: WI-V3.0.0.32483 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.0.32483 Firebird 3.0"
on disk structure version 12.0
SQL>
SQL> set term ^;
SQL>
SQL> create or alter procedure test_procedure(id integer, p_from_date date)
CON> as
CON>
CON>   declare variable from_date date;
CON>   declare variable to_date date;
CON>
CON> begin
CON> end
CON> ^
SQL warning code = 301
-DATE data type is now called TIMESTAMP
-SQL warning code = 301
-DATE data type is now called TIMESTAMP
-SQL warning code = 301
-DATE data type is now called TIMESTAMP
SQL>
SQL> set term ;^
SQL> show procedure;
Global procedures

Procedure Name                    Invalid Dependency, Type
================================= ======= =====================================
TEST_PROCEDURE
SQL>
SQL> show procedure test_procedure;
Procedure text:
=============================================================================
declare variable from_date date;
  declare variable to_date date;

begin
end
=============================================================================
Parameters:
ID                                INPUT INTEGER
P_FROM_DATE                       INPUT TIMESTAMP
SQL> commit;
SQL>
SQL> drop database;
SQL> exit;

Reagrds,
Vlad