|Subject||Re: SP Parameter DEFAULT and Domains|
--- In email@example.com, Thomas Steinmaurer <ts@...> wrote:
> I see no reason that DEFAULT NULL is part of the parameter list for theThanks Thomas for your response. I get your point. I don't have a DEFAULT in the DOMAIN though in which case I might want to use DEFAULT NULL in the SP parameters, but it does not stick for me.
> domain, if the underlaying domain has already DEFAULT NULL defined.
> For example:
> CREATE DOMAIN D_INT AS
> DEFAULT NULL
> CREATE DOMAIN D_INT2 AS
> I end up with the DDL for a procedure using both domains and explicitly
> using DEFAULT NULL for the second in the SP parameter list:
> SET TERM ^^ ;
> CREATE PROCEDURE P_1 (
> P1 D_INT,
> P2 D_INT2 DEFAULT NULL) AS
> END ^^