Trying to execute an Oracle stored function in Qlik Sense (Feb 2018):
LIB CONNECT TO '*****';
LOAD
*
;
SQL
SELECT {?= call MSO.f_get_data('01-Dec-2017')};
However it fails with this error:
Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 923, ErrorMsg: ORA-00923: FROM keyword not found where expected
The error occurred here:
?
The driver: Qlik ODBC for Oracle. The function is executed successfully when run from Oracle SQL Developer.
What am I doing wrong?