Wrong returnvalue on userdef function
Hi,
I have written several functions that give me different values from another database. All functions except one will return a value. The function shown below only provides OK back.
What am I doing wron
CREATE DEFINER=`mysql`@`%` FUNCTION `getNextSysNumber`( c_number_type varchar(64)) RETURNS int(18)
BEGIN
DECLARE nextnumber INTEGER DEFAULT 0;
SELECT
synewnumber.LastNumber
INTO nextnumber FROM
synewnumber
WHERE
UPPER(TRIM(synewnumber.TableName)) = UPPER(TRIM(c_number_type));
SET nextnumber = nextnumber + 1;
RETURN nextnumber;
END
Subject
Views
Written By
Posted
Wrong returnvalue on userdef function
1656
June 26, 2019 01:39AM
407
June 26, 2019 11:19AM
419
June 29, 2019 01:11AM
395
June 29, 2019 12:21PM
448
June 30, 2019 04:17AM
391
June 30, 2019 11:24AM
393
July 01, 2019 12:39AM
407
July 01, 2019 09:43AM
403
July 03, 2019 03:28AM
409
July 03, 2019 11:15AM
437
July 08, 2019 02:00AM
381
July 08, 2019 09:29AM
376
July 09, 2019 07:44AM
361
July 09, 2019 01:52PM
390
July 10, 2019 01:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.