Execute a Stored Procedure in Qlik Sense

[joaopaulo_delco]

Hello

       After I update Qlik Sense to Feb/2019 version,  a problema began to occur in my script that execute a oracle stored procedure.

My Script is:

LIB CONNECT TO 'Oracle MDLog (qliksense_administrador)';

SQL {CALL infomlog."TST_MONITORACAO_PEDIDOS_VENDA"};  // the follow erros appears here

QVX_UNEXPECTED_END_OF_DATA: Unable to get column information for the fields that are used in the query: Referência de objeto não definida para uma instância de um objeto.: SQL {CALL infomlog."TST_MONITORACAO_PEDIDOS_VENDA"}

Can someone help me?

On nov/2018 version was working well. 

[dplr-rn]

Did you enable legacy mode?

check below

---

If you want to use Execute the following conditions need to be met:

You must run in legacy mode (applicable for Qlik Sense and Qlik Sense Desktop).
You need to set OverrideScriptSecurity to 1 in Settings.ini (applicable for Qlik Sense).

Settings.ini is located in C:\ProgramData\Qlik\Sense\Engine\ and is generally an empty file.

---

https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

[joaopaulo_delco]

I enable to legacy mode and set de Settings.ini to OverrideScriptSecurity. Also restart de Qlik Sense Engine Service but not solve the problem. The same error occurs.

This is the content of my Settings.ini file:

[Settings 7]
OverrideScriptSecurity=1

[joaopaulo_delco · Accepted solution]

I was using a direct Oracle connection.

I changed the connection to OLE DB and the problem was solved.