Subject | domains inside Stored Procedures |
---|---|
Author | Adam |
Post date | 2005-06-02T05:09:54Z |
I probably should ask this on a different list but I wasn't sure which
one.
Is there any plans to allow you to define the input, returning
parameters and variables within stored procedures (and variables
within triggers) by using domains?
eg:
CREATE DOMAIN "STREETADDRESS" AS VARCHAR(70) default '';
CREATE PROCEDURE SETEMAILADDRESS
(
ADDRESS STREETADDRESS
)
AS
...
etc
It would make it easier to enforce a standard length and data type for
different items.
Adam
one.
Is there any plans to allow you to define the input, returning
parameters and variables within stored procedures (and variables
within triggers) by using domains?
eg:
CREATE DOMAIN "STREETADDRESS" AS VARCHAR(70) default '';
CREATE PROCEDURE SETEMAILADDRESS
(
ADDRESS STREETADDRESS
)
AS
...
etc
It would make it easier to enforce a standard length and data type for
different items.
Adam