cancel
Showing results for 
Search instead for 
Did you mean: 

Sap Cloud Platform: Error: (dberror) 9 - index out of bounds

0 Kudos

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

Accepted Solutions (0)

Answers (0)