Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Connecting to an Oracle Package

Hi,

I want to get data from an oracle DB. DBA dosent want to give direct access, but have created an Oracle Packages i can use.

The packages i want to collect data from is called "STATISTICS" and the function is INBOUND_TRAFFIC(datetime, datetime)

I expect it to return 4 fields in each row.

Is this possible in Qlikview? Can i connect to this package and return the data?

2 Replies
MVP & Luminary
MVP & Luminary

Re: Connecting to an Oracle Package

LET vDatetime1 = now()          // just an example, replace with something useful

LET vDatetime2 = now()-1     // same as above

TableX:

SQL select STATISTICS.INBOUND_TRAFFIC ( $(vDatetime1), $(vDateTime2) )

from dual;

Give the two datetime parameters proper values and make sure they're the data type that the package function expects.

You could ask your dba to show you how to call the package in for example sqlplus. That would give you a better feel for how things work.


talk is cheap, supply exceeds demand
Not applicable

Re: Connecting to an Oracle Package

This dosent seem to work, mabye because the Oracle Packages returns a REF CURSOR?