SAP DBTech JDBC: [7]: feature not supported: Aggregate function doesn't support column with array/lob type: line 89 col 27 (at pos 3223)

[mansonlvx]

hi，i use u code "p_basecol_view_usage.sql " to create the procedure, but get error info:

Could not execute 'create procedure p_basecol_view_usage( -- schema name LIKE pattern to look for. p_schema_name ...'
SAP DBTech JDBC: [7]: feature not supported: Aggregate function doesn't support column with array/lob type: line 89 col 27 (at pos 3223)

and my hana version is:
SAP HANA, express deition 2.0 SPS03 server-plus-apps version

can u solve this problem?

[wazdarocsta]

Look at the data type of the column you are trying to do the aggregation on. You may need to adjust it by using the TO_NVARCHAR() or similar TO_ function that ships with HANA