MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Can I (Is it safe) to use Recursive Stored Procedures in Mysql
Posted by: Ashley T
Date: January 18, 2006 09:21AM

Hi,

I check on a post somewhere a complaint about a bug where 4 or so levels or nested procedures would crash a server.

Now I'd like to use a recursive stored proc (calls it self, which calls itself, and so on)
Does Mysql support this and is it safe or am I looking for trouble.

It shouldnt have to recure more than 4 or 5 times... but is otherwise unlimited.

(I need to update children objects where theres can be mutiple Parent-child relationship.)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Can I (Is it safe) to use Recursive Stored Procedures in Mysql
2071
Ashley T
January 18, 2006 09:21AM
Re: Can I (Is it safe) to use Recursive Stored Procedures in Mysql
1365
Per-Erik Martin
January 18, 2006 09:31AM
Re: Can I (Is it safe) to use Recursive Stored Procedures in Mysql
1402
Kassi
January 22, 2006 07:12AM
Re: Can I (Is it safe) to use Recursive Stored Procedures in Mysql
1293
Roland Bouman
January 22, 2006 07:28AM
Re: Can I (Is it safe) to use Recursive Stored Procedures in Mysql
1287
Kassi
January 22, 2006 07:49AM
Re: Can I (Is it safe) to use Recursive Stored Procedures in Mysql
1408
Roland Bouman
January 18, 2006 02:36PM


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.