Error in creating Procedure in my SLQ workbench

CREATE PROCEDURE temp (IN empId INT)
        BEGIN
         DECLARE emptype VARCHAR;
            SELECT emptype = qoute(emptype) FROM dms_document WHERE id =  empid;
                SELECT emptype,

     CASE  
    WHEN emptype = 'P' THEN doctype;

    ELSE 'No Documents required';
    END CASE ;
    FROM dms_report WHERE pilot = 1
End;

i am truing create procure but i am getting keyword Error why this Error coming please help me i am trying to create procure in my sqlworkbench .


Source: mysql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.