on 12-05-2015 3:01 AM
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!
Documentation to the rescue! CALL - SAP HANA SQLScript Reference - SAP Library
CREATE PROCEDURE SingelRoute1(IN STARTSTOP NVARCHAR(40),
IN ENDSTOP NVARCHAR(40),
OUT OUT_ROUTE ROUTE)...
Number of parameters defined: 3 (2 IN, 1 OUT).
call "TRAFFIC"."SINGELROUTE"('安美居','任家口');
Number of parameters provided in call: 2 (2 IN).
Error message says:
Wrong number or types of parameters in call
Solution: provide correct amount of parameters. In this case, add the OUT parameter.
call "TRAFFIC"."SINGELROUTE"('安美居','任家口', ?);
Tataaa!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.