Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

Stored procedure execution help

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.

3 Replies

Re: Stored procedure execution help

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
Contributor

Re: Stored procedure execution help

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.

sasiparupudi1
Honored Contributor III

Re: Stored procedure execution help

Community Browser