Hi people,

Let's say I have domains defined as:

CREATE DOMAIN VC16 AS VARCHAR(16)
CREATE DOMAIN MYDATE AS DATE

Is there a way that I can do something like this?

CREATE PROCEDURE SP_TMP (
pFIRST_DATE MYDATE,
pLAST_DATE MYDATE
)
AS
DECLARE VARIABLE NAME VC16;
DECLARE VARIABLE LASTNAME VC16;
BEGIN
..


When I try do create a stored procedure like this, Firebird says it
doesn't know anything about MYDATE and VC16. And when I create a
stored procedure by typing the full field definitions, it creates new
domains as RDB$4269, RDB$4270, RDB$4271 and so on.. As you see I have
already many domains so wouldn't it be nice if I could reduce some?
(I have 162 tables, 151 procedures, 90 users, 3.5gb firebird file)

Thank you very much for any ideas.