Both Oracle and SQL Server supports this behaviour, so it seems to be
possible. Probably the constraints/defaults assigned to the domain
are checked when adding a value to the database.

/Pär Fahlén

--- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
> 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@e...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >