On 28/11/2013 07:36, Robbert-Jan wrote: > Hi, > Domain defaults seem not to be applied for SP ending parameters, see > case below. > Is this as designed, or a bug, or a request? I just want to be sure > before I issue a Jira tracker. > CREATE DOMAIN MyDomain1 AS INTEGER DEFAULT 1 > CREATE PROCEDURE MyProcedure1 (Var1 MyDomain1) RETURNS (Var2 INTEGER) AS > BEGIN > Var2 = Var1; > SUSPEND; > END > SELECT * FROM MyProcedure1 > Dynamic SQL Error > Input parameter mismatch for procedure MYPROCEDURE1 > SQL code: –902 > I expected 1 in the result set. > This is as designed. Number of necessary parameters passed are calculated in relation to the DEFAULTs present in the procedure create/alter syntax.
Adriano ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
