I'm using 7.6.00.10.
CREATE FUNCTION GIS.GET_TARIF (
p_resid varchar,
p_date date) returns FIXED(20,2) AS
VAR
f FIXED(20,2);
BEGIN
select tarif into :f from gis.fullrestype where resid=:p_resid;
return f;
END;
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-9000 POS(159) System error: Not yet
implemented:parameter of unknown size
I tried another variant
CREATE FUNCTION GIS.GET_TARIF (
p_resid varchar(10),
p_date date) returns FIXED(20,2) AS
f FIXED(20,2);
BEGIN
select tarif into :f from gis.fullrestype where resid=:p_resid;
return f;
END;
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-9000 POS(159) System error: Not yet
implemented:parameter of unknown size
How can I create function?
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]