topic Calling Oracle stored function fails in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Calling-Oracle-stored-function-fails/m-p/43951#M268 <HTML><HEAD></HEAD><BODY><P>Trying to execute an Oracle stored function in Qlik Sense (Feb 2018):</P><P></P><P>LIB CONNECT TO '*****';</P><P></P><P>LOAD</P><P>*</P><P>;&nbsp;&nbsp; </P><P>SQL</P><P>SELECT {?= call MSO.f_get_data('01-Dec-2017')};</P><P></P><P>However it fails with this error:</P><P></P><P class="edc_error" style="padding: 0 10px; background: rgba(255, 38, 38, 0.2); color: #595959; font-family: 'Courier New'; font-size: 13px;">Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 923, ErrorMsg: ORA-00923: FROM keyword not found where expected</P><P class="headline edc_error" style="padding: 0 10px; background: rgba(255, 38, 38, 0.2); font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;">The error occurred here:</P><P class="edc_error" style="padding: 0 10px; background: rgba(255, 38, 38, 0.2); color: #595959; font-family: 'Courier New'; font-size: 13px;">?</P><P></P><P>The driver: Qlik ODBC for Oracle. The function is executed successfully when run from Oracle SQL Developer.</P><P></P><P>What am I doing wrong?</P></BODY></HTML> Fri, 02 Mar 2018 21:19:11 GMT Anonymous 2018-03-02T21:19:11Z Calling Oracle stored function fails https://community.qlik.com/t5/Connectivity-Data-Prep/Calling-Oracle-stored-function-fails/m-p/43951#M268 <HTML><HEAD></HEAD><BODY><P>Trying to execute an Oracle stored function in Qlik Sense (Feb 2018):</P><P></P><P>LIB CONNECT TO '*****';</P><P></P><P>LOAD</P><P>*</P><P>;&nbsp;&nbsp; </P><P>SQL</P><P>SELECT {?= call MSO.f_get_data('01-Dec-2017')};</P><P></P><P>However it fails with this error:</P><P></P><P class="edc_error" style="padding: 0 10px; background: rgba(255, 38, 38, 0.2); color: #595959; font-family: 'Courier New'; font-size: 13px;">Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 923, ErrorMsg: ORA-00923: FROM keyword not found where expected</P><P class="headline edc_error" style="padding: 0 10px; background: rgba(255, 38, 38, 0.2); font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;">The error occurred here:</P><P class="edc_error" style="padding: 0 10px; background: rgba(255, 38, 38, 0.2); color: #595959; font-family: 'Courier New'; font-size: 13px;">?</P><P></P><P>The driver: Qlik ODBC for Oracle. The function is executed successfully when run from Oracle SQL Developer.</P><P></P><P>What am I doing wrong?</P></BODY></HTML> Fri, 02 Mar 2018 21:19:11 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Calling-Oracle-stored-function-fails/m-p/43951#M268 Anonymous 2018-03-02T21:19:11Z