on 06-15-2015 10:44 AM
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.
Solved !
Created a read procedure with OP as a declarative variable.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.