| Subject | Using domains in stored procedures | 
|---|---|
| Author | parfahlen | 
| Post date | 2002-05-14T08:37:37Z | 
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?
            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?