MySQL Forums
Forum List  »  Stored Procedures

Re: Wrong returnvalue on userdef function
Posted by: Franz Balleis
Date: July 01, 2019 12:39AM

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


08:26:26 select getNextSysNumber('sg_sys_objektdaten') LIMIT 0, 1000 OK 0.000 sec

Options: ReplyQuote

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.