OPTIMIZE TABLE in stored procedure

[Anton Shchirov]

I wrote such procedure

CREATE PROCEDURE sp_test()
BEGIN
  OPTIMIZE TABLE my_table;
END

When you call getting the error "sp_test can't return a result set in the given context"

I understand - OPTIMIZE returns result set with the results of their work. I do not need these results. As much as I suppress them?

Server version: 5.1.45-community



Edited 1 time(s). Last edit at 01/19/2012 04:20AM by Anton Shchirov.