cancel
Showing results for 
Search instead for 
Did you mean: 

Table operations using Scalar UDF

Former Member
0 Kudos

Hello all,

There has been one scenario in Oracle wherein we pass two Input Parameters to a scalar function; this UDF processes some SELECT statements and DDL operations on schema tables and results one value in form of a VARCHAR variable as output. As is its a scalar one, we can use it SELECT statement further as


SELECT my_scalar_udf (a,b) AS output

FROM dummy;

We are trying to create such Scalar UDF in HANA Studio but got this error :

feature not supported: Scalar UDF does not support TABLE operations: line 12 col 1 (at pos 248)

Please suggest any other way/flow to achieve the scenario. We are using SAP HANA SPS8 Revision 85.

Thanks in adv.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Solved !

Created a read procedure with OP as a declarative variable.

Answers (0)