Skip to Content
0

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

Apr 11 at 03:05 PM

30

avatar image

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

codigo.jpg (95.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers