Hi *,

let's have this stupid SP:
create or alter procedure TEST
returns (
    TEST D_PRIMARY)
as
begin
  if (1=0) then
  begin
    suspend;
  end
end

The D_PRIMARY is BIGINT NN.

Calling it (on Firebird 2.5.5) `execute procedure test;` results in:
validation error for variable TEST, value "*** null ***".
At procedure 'TEST' line: 6, col: 3.

I don't understand why... Why there's validation? The SUSPEND is never
called, so...

-- 
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to