MySQL Forums :: Stored Procedures :: Writing my first Stored Procedure


Advanced Search

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?

Thanks

Options: ReplyQuote


Subject Views Written By Posted
Writing my first Stored Procedure 2702 Sean Traber 10/22/2010 10:45AM
Re: Writing my first Stored Procedure 716 Sean Traber 10/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.