Stored procedure execution help - Qlik Community

mahitham · ‎2018-04-10

Hi Experts,

I am very new to stored procedures execution in Qliksense.

I am trying to execute one stored procedure with sample syntax like below by following this thread

LIB CONNECT TO ...

load *;

SQL exec ....;

Here i am getting error like below

Connector reply error: SQL##f - sqlstate:37000, Errorcode:0,

ErrorMsg: [Oracle][ODBC] Syntax error or access violation

is the above stored procedure execution syntax will applicable to oracle as well please help me to resolve the error.

devarasu07 Could you please help me )

Thanks in advance.

MK_QSL · ‎2018-04-10

Try connecting using OLE DB Data Source

Go to Script

Create new connection

Select OLE DB

Select Provide

Microsoft OLE DB Provider for SQL Server

Enter Data Source

Use Security (either windows or username and password)

Test Connection.

Now click Insert Connection String from the right hand side.

and use

load *;

SQL exec ....;

mahitham · ‎2018-04-10

Hi Manish,

Thanks for your reply. Actually its a oracle database.

I have found one thread with similar error but its related to qlikview.

This thread contains read and write access settIngs how to and where to add these settings in qliksense. Please help me on this.

sasiparupudi1 · ‎2018-04-10

Try this