Stuart, Try a CLEAR VAR STP_RETURN at the top of your stored procedure. Maybe some other SP returned a different data type, and left it hanging around.
Bill On Feb 9, 2008 1:59 PM, Stuart Cohen <[EMAIL PROTECTED]> wrote: > I traced the following stored procedure: > > > SET VAR vcountnum INTEGER = NULL > SELECT COUNT(*) INTO vcountnum INDIC ivcountnum FROM login > RETURN .vcountnum > > After running the third line I get the following error message: > > --ERROR- (STP_RETURN) is a reserved word or contains illegal characters > (3065). > > Does anybody see what I am doing wrong? > > > Stuart J. Cohen, Ph.D. > Major, Medical Service Corps > Research Specialist > Walter Reed Army Medical Center > National Disaster Medical System Federal Coordinating Center > Phone: 202-782-3636 > Cell: 301-514-3975 > Fax: 202-782-4360 > E-mail: [EMAIL PROTECTED] > > >
