今天我使用 hana的计算视图做一个类似oracle存储过程的东西,其他转换都成功了,就一个引用进函数,在该函数上输入动态参数,代码例子如下:var_backnum = select org_no, valid, backnum FROM "HC_USER"."95598_S_95598_WKST" A,
"HC_USER"."95598_S_WKS_DEAL" B,
"HC_USER"."95598_S_COMPLAIN_HANDLE_2" D
WHERE A.APP_NO = B.APP_NO
AND A.ORG_NO = B.ACCEPT_ORG_NO
AND A.APP_NO = D.APP_NO
AND B.PRE_ACT_NAME in ('回访前审核',
'投诉评审')
AND B.BACK_FLAG = '12'
AND A.BUSI_TYPE_CODE = '004'
AND A.ARC_DATE IS NOT NULL
-----这里开始报错(下面这个是函数) AND "HC_USER"."95598_IFSTATORG"('35401',
'35401',
A.ORG_NO,
'35401') = 1
GROUP BY ORG_NO ;
然后报的错误为feature not supported:field or table alias is not allowed as an input of table functions:line 44 col 3........... 请问一下函数是不能调用动态参数或者列名的参数是吗?那这样子的话,我该怎么转换。怎么解决这种问题!!!