Subject domains inside Stored Procedures
Author Adam
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