Steve, the return in the stored procedure transfers control back to the calling program. While there can be code after the RETURN .vMYSPValue it will not get executed. So you can clean up all variables except the variable used in the return.
Regards, Ken ----- Original Message ----- From: "Wills, Steve" Date: Friday, September 19, 2008 2:05 pm Subject: [RBASE-L] - Question About RETURN [vValue] in Stored Procedures To: [email protected] (RBASE-L Mailing List) > I have a question about RETURN and RETURN .vMySPValue. At what point > does control pass back to the caller of the Stored Procedure : > > > "RETURN .vMySPValue" > > "RETURN", assuming that a RETURN can and does follow a "RETURN > .vMySPValue" > > After last statement of Stored Procedure, if there is no form of > "RETURN", although I think that a well-written SP should have > some sort > of RETURN ... > > I ask because I want to know where to CLEAR my VARIABLES that are > local_to||used_by the SP. > > > Thanks, > Steve in Memphis > > > > J. Stephen Wills > Program Manager, Research Informatics > Office of the Vice Chancellor for Research > University of Tennessee Health Science Center > 62 S. Dunlap, Suite 400 > Memphis, TN 38163 > Office: 901-448-2389 > FAX : 901-448-7133 > > >
