on 04-11-2018 4:05 PM
Hi everyone,
I am having an error when creating a store procedure in Sap cloud Platform, what I want is to load only the data of a range of dates and it is what happened through parameters, the error that I get is: Error: (dberror) 9 - index out of bounds: "PREDICTIVE". "T2B_OPE_SQL": line 24 col 4 (at pos 862): [9] (range 3): index out of bounds: param index exceeded the param size 0 , but 1
The code is:
and when I want to execute the store procedure I do it with:
call "PREDICTIVE"."T2B_OPE_SQL"('2018-01-01','2018-01-07')
and I always get the error:
SQL Editor) Could not execute 'call "PREDICTIVE"."T2B_OPE_SQL"() ...'
Error: (dberror) 9 - index out of bounds: "PREDICTIVE"."T2B_OPE_SQL": line 24 col 4 (at pos 862): [9] (range 3): index out of bounds: param index exceeded the param size 0, but 1
The data type of the "samplingDate" field NVARCHAR (10).
Could you please help me because that error comes out?
thank you very much
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.