Executing Oracle Stored Procedure from Qlikview not working

[#1]

i need to call a stored procedure on Oracle unix server with parameters, which fills a table that i later want to load to Qlikview.

So far, i have tried all the ideas i found but with no luck. I'll appreciate your ideas/examples of similar working scripts

[cchristenson2]

Hi, know that this is closed, but wondering if someone could help me out, trying to execute the following code and wondering why it might not be working:

SQL Execute/Exec/Call EPIC_UTIL.ESP_CR_ALTERED_ROWS 'HSP_ACCOUNT','CLARITY',trunc(sysdate-1),sysdate,true;

$(vTableName):
SQL
SELECT src.*,
cdc.CR_UPD_DATE
from HSP_ACCOUNT src
inner join epic_util.cdc_HSP_ACCOUNT cdc on src.HSP_ACCOUNT_ID = cdc.HSP_ACCOUNT_ID
where rownum < 100;

I've tried the commands in italics above. It works flawlessly if I run it in SQL Developer with Exec in there. Any ideas?