Skip to Content
0

Pass ARRAY in Procedure

Aug 08, 2017 at 08:27 PM

30

avatar image
Former Member

Hello Experts,

To make it simple, I am trying to pass an array value into a variable. I declared array as

arr = ARRAY('city1', 'city2', 'city3')

Before I start using in loop using array length..., I am trying to test by passing 1 value into a variable like var_city = arr[1]

It is failing saying 'SAP DBTech JDBC: [266]: inconsistent datatype: ARRAY is invalid function argument type:...'


Here is what I declared for variables.

DECLARE arr NVARCHAR(15) ARRAY;

DECLARE var_city VARCHAR(15);

Please help me out.

Thanks

Ravi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers