MySQL Forums
Forum List  »  Stored Procedures

Writing my first Stored Procedure
Posted by: Sean Traber
Date: October 22, 2010 10:45AM

I'm just starting to learn MySql for a class I'm taking. I have a simple table Users with about 8 columns in it, and I tried to write a stored procedure to just retrieve all the info. The problem is when I call the stored procedure I get this error:

Thread stack overrun: 4904 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

It seems as though it's running out of memory, although there are only 4 rows in the table, and it works just fine if I just type in SELECT * FROM Users; Anyone know why I'm getting this error, or how to fix it?


Options: ReplyQuote

Written By
Writing my first Stored Procedure
October 22, 2010 10:45AM
October 22, 2010 11:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.