Witam
chce stworzyć poniższą procedurkę w bazie:

[SQL] pobierz, plaintext 
CREATE PROCEDURE crm_timetable_msg (IN userid INTEGER, OUT text VARCHAR(255))
BEGIN SELECT timetable_description INTO text FROM timetable WHERE timetable_start < NOW() AND (timetable_end>NOW() OR timetable_end IS NULL) AND user_id = userid AND active=1
END
[SQL] pobierz, plaintext 

i dostaje:

[SQL] pobierz, plaintext 
MySQL ERROR:
 
You have an error IN your SQL syntax; CHECK the manual that corresponds TO your MySQL server version FOR the RIGHT syntax TO USE near 'SELECT timetable_description INTO text FROM timetable WHERE timetable_start < ' at line 3
 
QUERY:
 
CREATE PROCEDURE crm_timetable_msg (IN userid INTEGER, OUT text VARCHAR(255))
BEGIN SELECT timetable_description INTO text FROM timetable WHERE timetable_start < NOW() AND (timetable_end>NOW() OR timetable_end IS NULL) AND user_id = userid AND active=1
END
[SQL] pobierz, plaintext 

Czy ktoś może mi powiedzieć, gdzie popełniam błąd składni ? bo albo ja już mylę bazy, albo nie wiem...

.... _msg (IN userid INTEGER, OUT text VARCHAR(255)) <- czy tutaj miał być drugi nawias?