Thanx Woody. That was the problem. It compiles fine now. On Thu, Apr 5, 2012 at 4:02 PM, Woody <[email protected]> wrote:
> ** > > > From: "Mags Phangisa" <[email protected]> > > > Hi everyone, > > > > The following stored procedure won't compile successfully: > > > > CREATE PROCEDURE SPS_PYMT (SDT Date, EDT Date) > > RETURNS > > (MBR DATE, POL VARCHAR(20), PTY CHAR(4), BNK DATE, AMU DECIMAL(10,2), ERR > > CHAR(4)) > > AS > > BEGIN > > FOR > > SELECT MBRID, POLNO, PTYPE, BNKDT, AMUNT, ERROR > > from PYMT where BNKDT>=:SDT and BNKDT<=:EDT > > INTO :MBR, :POL, :PTY, :BNK, :AMU, :ERR > > DO > > SUSPEND; > > END > > > > It brings up the following error: > > Unexpected end of command - line 11, column 3 > > > > Line 11 is where SUSPEND is. > > > > I gather it is something small that brings up the error but I just can't > > find it. Pls assist. > > Did you set the terminator to something other than semi-colon (;) first? > > SET TERM ^; > > CREATE PROCEDURE ... > ... > END^ > > SET TERM ;^ > > Woody (TMW) > > > [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
