Subject Re: Using domains in stored procedures
Author parfahlen
Well, thanks for the rapid answer even though it was not really what
I wanted to hear. Any idea why this is not possible? I mean, it is
one of the good things with domains (in other products). Anyway,
thanks again.

/Pär Fahlén

--- In ib-support@y..., "Thomas Steinmaurer" <ts@i...> wrote:
> A short answer. You can't use domains in stored procedures.
>
> Regards,
> Thomas Steinmaurer
> http://www.iblogmanager.com
>
> > -----Original Message-----
> > From: parfahlen [mailto:parfahlen@y...]
> > Sent: Tuesday, May 14, 2002 10:38 AM
> > To: ib-support@y...
> > 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@e...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
> >