Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 2nd, 2012  |  syntax: PL/SQL  |  size: 0.40 KB  |  hits: 45  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. CREATE DEFINER = 'root'@'localhost' FUNCTION `test`(
  2.         param1 TINYINT
  3.     )
  4.     RETURNS tinyint(4)
  5.     NOT DETERMINISTIC
  6.     CONTAINS SQL
  7.     SQL SECURITY DEFINER
  8.     COMMENT ''
  9. BEGIN
  10.  
  11.   DECLARE iTags TINYINT DEFAULT 0;
  12.  
  13.   SELECT COUNT(*) INTO iTags FROM `socrbase`;
  14.  
  15.   IF param1 < 3 THEN
  16.     SET param1 = param1 + 1;
  17.     SET iTags = test(param1);
  18.   END IF;
  19.   RETURN iTags;
  20. END;