Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Execute a Stored Procedure in Qlik Sense
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.
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 ....;
Hi Manish,
Thanks for your reply. Actually its a oracle database.
I have found one thread with similar error but its related to qlikview.
Executing Oracle Stored Procedure from Qlikview not working
This thread contains read and write access settIngs how to and where to add these settings in qliksense. Please help me on this.
Try this