Re: -6003 Duplicate result table name

[Alexey Gaidukov]

Other variant

CREATE FUNCTION KASSA.FIO(
  p_cartnum integer) returns varchar AS
VAR
  f varchar(200);
BEGIN
  TRY
      SELECT pats.fam || ' ' || pats.name ' ' || pats.nname into :f
      from gis.pats where cartnum=:p_cartnum;
  CATCH
      IF $rc = 100 THEN
          return null
      ELSE
          STOP(-20013, $errmsg);
  return f;
END;


General error;-8046 POS(171) Conversion from UNICODE impossible: FFFF




--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]