--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:

> Is there any plans to allow you to define the input, returning
> parameters and variables within stored procedures (and variables
> within triggers) by using domains?

Moin!
I did not read the plans about this, but I would not encourage you too
much to expect this soon.

Too much work to be considered for that, I think.

SPs are COMPILED to the server. To use domains, which are quite
flexible (and THIS is their main advantage) inside SPs, you would
have to make sure that nobody is accessing/running the SP while
changing the source-code and compiling it again. Nothing short of a
database-shutdown would accomplish this.
And away goes all your flexibility...
In addition, the server must be given right and ability to change YOUR
sourcecode for the SP and to recompile it.

ciao,
André