Connecting Tech Pros Worldwide Forums | Help | Site Map

Procedure: error -1?

Newbie
 
Join Date: Jun 2008
Posts: 6
#1: Jun 29 '08
This must be a pretty newbie mistake, but I'm still flummoxed by it. I created a very simple procedure:

Expand|Select|Wrap|Line Numbers
  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
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#2: Jul 1 '08

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