Login or Sign up Help | Site Map
Connecting Tech Pros Worldwide
Bytes > Forums - Questions and Answers > MySQL Forum

Procedure: error -1?

Question posted by: AdamGr (Newbie) on June 29th, 2008 04:57 AM
This must be a pretty newbie mistake, but I'm still flummoxed by it. I created a very simple procedure:

Code: ( text )
  1. create procedure deleteAll ()
  2. begin
  3. delete from test1;
  4. delete from test2;
  5. end


but when I run it I get a Error code -1: Error executing SQL command.

The strangest part is that it still does what its supposed to, the data IS deleted from those two tables. So if its necessary I can go on with my life; but I would like to know why the error is occurring.

Thanks,
Adam
Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).
amitpatel66's Avatar
amitpatel66
Moderator
1,843 Posts
July 1st, 2008
02:11 PM
#2

Re: Procedure: error -1?
The procedure got compiled successfully without any error?

If Yes, then the problem should be in the way you are calling a procedure??
Reply
Reply
Not the answer you were looking for? Post your question . . .
182,371 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Top MySQL Forum Contributors
Quick Browse:
Communities / Archives
XML / CSS | HTML | Javascript | PHP | Perl | Visual Basic | Python | C++ / C | Java | .NET / C# / VB / XML / ASP.net | ASP
PostgreSQL | MS SQL | Oracle | IBM DB2 | MS Access | MySQL

About Bytes | Sitemap | Privacy Policy | Terms of Use
Copyright 1995-2008 Bytes.com. All rights Reserved