At 09:16 AM 5/04/2004 +0200, you wrote:

>Hi!
>
>Why is it not possible to use domains in declaring a stored procedure?
>Could this be changed?

Not currently. If it could have been done, it would have been done by now,
since it would be a useful move towards a user-defined type, and lots have
asked for it.

The problem is, SPs are compiled. What happens if you could use a domain to
define an argument or a variable and the domain specification
changed? It's no good saying "but my domain spec isn't going to
change". Many people do change them.

Be clear that a domain is not a type: it is a specification, a set of
attributes. Firebird doesn't have user-defined types. Period.

/heLen