Error : string is incompatible with varchar3

[Former Member]

Hi All,

How to remove error "String is incompatible with varchar3" in hana while processing array.

Array is of varchar(30) which is initialized with values as 'hello','hello1','hello2'.

Please help.

[former_member184768]

Hi Amit,

Can you please provide more details on what exactly are you trying to do. Is it a function or a Procedure ?

Ravi

[Former Member]

Hi Ravindra,

Below is my requirement.

From UI i am getting three input parameters.

1) First input parameter is array which is containing columns of existing view.

2) Second parameter is also an array which is containing columns of existing view.

3) Third parameter containing name of existing view.

Above two array containing columns of existing view.Name of view is passed in third parameter.

Now i need to send data through procedure by selecting columns from view. All array value will be char. How i should pass the data from procedure as columns are dynamic? for example --

If first array containing column as name,id and second array containing column as firstname,lastname and third parameter containing view name as ABC.Then i need to return data by writing select name,id,firstname,lastname from ABC. all these data need to pass through procedure. I am not sure upto how much extent it is possible in hana.

Please help.