Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calling Oracle stored function fails

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?

0 Replies