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.

Kind regards,
Robert.
------------------------------------------------------------------------------
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

Reply via email to