Link to home
Start Free TrialLog in
Avatar of vijji_lakshmi
vijji_lakshmi

asked on

This command is not supported in the prepared statement protocol yet

Hi i am writing a procure to drop triggers as below.
CREATE PROCEDURE droptriggers7()

BEGIN

declare viewname varchar(80);

declare NO_MORE_ROWS BOOLEAN DEFAULT FALSE;

 

 

  DECLARE cursor1 cursor  FOR

SELECT trigger_name FROM INFORMATION_SCHEMA.TRIGGERS T where trigger_schema=(select database());
 

  DECLARE CONTINUE HANDLER FOR NOT FOUND SET NO_MORE_ROWS=true;

 

                        OPEN cursor1;

                        cursor_loop:LOOP

                            FETCH cursor1 INTO viewname;

                            IF NO_MORE_ROWS THEN

                                     LEAVE cursor_loop;

                            END IF;

 

                          SET @tmp_sql= CONCAT("DROP TRIGGER ",viewname);

                          PREPARE s1 FROM @tmp_sql;

                          EXECUTE s1;

                          DEALLOCATE PREPARE s1;



                        END LOOP cursor_loop;

                        CLOSE cursor1;

 

        SET NO_MORE_ROWS=false;

END

when iam calling this procedure iam getting
"This command is not supported in the prepared statement protocol yet" error.
please help how to reslove this problem.
Regds,
vijji
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial