Skip to Content
0
Former Member
Dec 05, 2015 at 03:01 AM

SAP HANA SQL Error Codes 1281,I want to know how to solve it

477 Views

here is my procedure

CREATE PROCEDURE SingelRoute1(IN STARTSTOP NVARCHAR(40),

IN ENDSTOP NVARCHAR(40),

OUT OUT_ROUTE ROUTE)

LANGUAGE SQLSCRIPT READS SQL DATA AS

BEGIN

OUT_ROUTE= SELECT DISTINCT

SR1.STOP AS "起始站点",

SR2.STOP AS "目的站点",

SR1.ROUTE AS "乘坐线路",

ABS(SR2.POS-SR1.POS) AS "经过的站点数"

FROM

STOP_ROUTE SR1,

STOP_ROUTE SR2

WHERE

SR1.ROUTE=SR2.ROUTE

AND SR1.STOP=:STARTSTOP

AND SR2.STOP=:ENDSTOP

UNION ALL

SELECT DISTINCT

SR3.STOP AS "起始站点",

SR4.STOP AS "目的站点",

SR3.ROUTE AS "乘坐线路",

ABS(SR4.POS-SR3.POS) AS "经过的站点数"

FROM

DTOP_ROUTE SR3,

DTOP_ROUTE SR4

WHERE

'SR3.ROUTE'='SR4.ROUTE'

AND SR3.STOP=:STARTSTOP

AND SR4.STOP=:ENDSTOP ;

END

and i used following code call the procedure

call "TRAFFIC"."SINGELROUTE"('安美居','任家口');

but i faced a problem with the error code 1281:

Wrong number or types of parameters in call

how should i solve this problem?

i need your help.thanks very much!