Skip to Content
avatar image
Former Member

Pass ARRAY in Procedure

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers