Hi,

> 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.

Most probably because there's more to a domain that simply a datatype.

A Domain can have more attributes, like:
- NOT NULL
- DEFAULT [value]
- CHECK [search condition]

How would these be used as parameters for a stored procedure? What
if you don't supply one? Or supply one as NULL while the domain is
defined as NOT NULL?

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> /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/
> > >
> > >
> > >
> > >
>
>
>
> 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/
>
>