where is the error

Hi , Thanks in advance , who can tell me what is the problem of this procedure ; system tell me i should modify the RETURNING SMALLINT , it told me the point of N is not correct . I run this procedure several time , but it not work today , why ???? I will be nervous by it. Thanks JunJian (jjdai@pek-co.cn.dhl.com) CREATE PROCEDURE get_tts( r_sorig CHAR(4) , r_sdest CHAR(4) , r_spudow SMALLINT , r_sprod CHAR(2) ) RETURNING SMALLINT ; BEGIN DEFINE tts SMALLINT ; DEFINE err_num INT ; SELECT MAX(comp_info_std) INTO tts FROM trans_std WHERE origin = r_sorig AND dest = r_sdest AND day_of_week = r_spudow AND product_code = r_sprod AND start_event_code = "PU" AND end_event_code = "DL" ; RETURN tts ; END END PROCEDURE ; 201: A syntax error has occurred. -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum