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.TRIGGER S 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
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.TRIGGER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.