Advertisement
Guest User

Untitled

a guest
Aug 21st, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. Executing SQL script in server
  2. ERROR: Error 1304: FUNCTION GET_NEXT_SEQ already exists
  3. SQL Code:
  4. CREATE DEFINER=`masteruser`@`%` FUNCTION `GET_NEXT_SEQ`(`SEQNAME` VARCHAR(50)) RETURNS varchar(50) CHARSET utf8
  5. BEGIN
  6. DECLARE CURVALUE INT;
  7. UPDATE sequence_log SET CURRENT_VALUE = (CURRENT_VALUE + 1) WHERE SEQUENCE_NAME = SEQNAME;
  8. SELECT CURRENT_VALUE INTO CURVALUE FROM sequence_log WHERE SEQUENCE_NAME = SEQNAME;
  9. RETURN LPAD(CURVALUE,9,0);
  10. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement