How to call Oracle Package from Qlik Sense

[Anonymous]

I have created the connection to Oracle using "Qlik ODBC Connector Package"

I have tried below calls but always returning ZERO rows.

1. SELECT package.abc('20Jun2017') as y from DUAL;

2. SELECT * from table(package.abc('20Jun2017'));   -- Getting rows in Oracle.

3. Exec package.abc('20Jun2017');

[Anonymous]

Appreciate quick help.Thanks in advance.