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]

Reply via email to