Re: where is the error
jjdai07@my-dejanews.com wrote:
> 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
As far as I know, this is the syntax error - there's no begin here. If you want
atransaction to be started, then use begin work and commit work.
Hope that helps,
Arun
> DEFINE tts SMALLINT ;
> DEFINE err_num INT ;
> <Snip>