> Is it possible to use Domains in Stored Procedures ?

Unfortunately, NO. :-(

I remember article by IB developer David Schnepper:
-------------------------
It is difficult to perform domain validation at input-output parameter of
stored
procedure (SP), for example

define domain age smallint check (age >=0 and age <=150)

Also it's difficult to support changing of domain in parameters of SP when
ALTER DOMAIN, ex.:

alter domain age float
-------------------------

Naturally, it doesn't make our life better. It just gives understanding 'why
no' :-)

Regards,
Sergey Balter

>
>
> Guido
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>