Subject | exception on case |
---|---|
Author | zayats |
Post date | 2006-03-23T14:34:46Z |
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.
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.