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?