MySQL Forums
Forum List  »  Stored Procedures

Re: multiple output from store procedure
Posted by: Jay Alverson
Date: February 07, 2009 04:28PM

Well, I don't see what the problem is...

That's what computers are for, to do complex, repetitive work and keep track of it all.

If you need the "single row" over and over, then see if you can either place it
into a TEMPORARY table or, into a CURSOR, for repeated use.

As for the "lot of variables" they probably don't take up too much space, from the size(s) you declared.

How long does the SP take to run ? Is that the issue ? Time ?
Does it cause your other users to suffer while it's running ?


Thanks, Jay

Options: ReplyQuote

Written By
February 07, 2009 03:58PM
Re: multiple output from store procedure
February 07, 2009 04:28PM

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.