Re: Wrong returnvalue on userdef function
Hi Peter,
the variable is nextnumber and the column name is LastNumber. So that can not be the reason. What I find strange is that with my other function exactly one record gets back see the function getNextOrdNumber (). On my problem function getNextSysNumber() only OK is reported.
select getNextOrdNumber('BE');
08:26:26 select getNextOrdNumber('BE') LIMIT 0, 1000 1 row(s) returned 0.875 sec / 0.000 sec
getNextSysNumber('sg_sys_objektdaten');
08:26:26 select getNextSysNumber('sg_sys_objektdaten') LIMIT 0, 1000 OK 0.000 sec
Subject
Views
Written By
Posted
1552
June 26, 2019 01:39AM
364
June 26, 2019 11:19AM
363
June 29, 2019 01:11AM
341
June 29, 2019 12:21PM
386
June 30, 2019 04:17AM
337
June 30, 2019 11:24AM
Re: Wrong returnvalue on userdef function
344
July 01, 2019 12:39AM
357
July 01, 2019 09:43AM
356
July 03, 2019 03:28AM
350
July 03, 2019 11:15AM
368
July 08, 2019 02:00AM
331
July 08, 2019 09:29AM
331
July 09, 2019 07:44AM
311
July 09, 2019 01:52PM
331
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.