A short answer. You can't use domains in stored procedures.

Regards,
Thomas Steinmaurer
http://www.iblogmanager.com

> -----Original Message-----
> From: parfahlen [mailto:parfahlen@...]
> Sent: Tuesday, May 14, 2002 10:38 AM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Using domains in stored procedures
>
>
> Hi!
>
> I would like to use domains when specifying input parameters for
> stored procedures but it doesn't seem to work. I have done like this:
>
> create domain id_type as int
>
> create procedure sp_test(a id_type)
>
> I get the following error :
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 1, char 21
> id_type
> Statement: create procedure sp_test(a id_type)
>
> Is this the way it should be or am I doing something wrong?
>
>
>
>
> 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/
>
>
>
>