Subject exception on case
Author zayats
Bases:
SQL Dialect : 1
ODS Version : 10.1
Firebird-1.5.2.4731 win32
Page Size : 8192

CREATE PROCEDURE NEW_PROCEDURE (
P DOUBLE PRECISION)
RETURNS (
VV VARCHAR(20) CHARACTER SET WIN1251)
AS
begin
VV = cast(P as varchar(6));
suspend;
end

1.
Input:
P1 = 0.011

Output:
P1 = 0.011

2.

Input:
P1 = 0.001

Output:
Error Message:
----------------------------------------
Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.

Help me. Im in exception.